eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_ACTION_ARCH dependencies on PAY_BALANCE_PKG

Line 3619: nvl(pay_balance_pkg.get_value(

3615: BEGIN
3616:
3617: if p_defined_balance_id is not null then
3618: ln_bal_value := fnd_number.number_to_canonical(
3619: nvl(pay_balance_pkg.get_value(
3620: p_defined_balance_id,
3621: p_balcall_aaid),0));
3622: end if;
3623:

Line 3935: pay_balance_pkg.set_context('JURISDICTION_CODE',

3931: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
3932: hr_utility.trace('Archiving for Jurisdiction = ' ||
3933: p_jurisdiction_tab(i).emp_jd);
3934:
3935: pay_balance_pkg.set_context('JURISDICTION_CODE',
3936: p_jurisdiction_tab(i).emp_jd);
3937:
3938: ln_bal_value := 0;
3939: ln_curr_withheld := 0;

Line 4513: pay_balance_pkg.set_context('JURISDICTION_CODE',

4509: lv_county_head_tax_exists);
4510: hr_utility.trace('COUNTY Archiving for Jurisdiction = ' ||
4511: p_jurisdiction_tab(i).emp_jd);
4512:
4513: pay_balance_pkg.set_context('JURISDICTION_CODE',
4514: p_jurisdiction_tab(i).emp_jd);
4515:
4516: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd,
4517: NULL);

Line 4698: pay_balance_pkg.set_context('JURISDICTION_CODE',

4694:
4695: hr_utility.trace('CITY Archiving for Jurisdiction = ' ||
4696: p_jurisdiction_tab(i).emp_jd);
4697:
4698: pay_balance_pkg.set_context('JURISDICTION_CODE',
4699: p_jurisdiction_tab(i).emp_jd);
4700:
4701: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd,
4702: NULL);

Line 4892: pay_balance_pkg.set_context('JURISDICTION_CODE',

4888:
4889: hr_utility.trace('PSD Archiving for Jurisdiction = ' ||
4890: p_jurisdiction_tab(i).emp_jd);
4891:
4892: pay_balance_pkg.set_context('JURISDICTION_CODE',
4893: p_jurisdiction_tab(i).emp_jd);
4894:
4895: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd,
4896: NULL);

Line 5055: pay_balance_pkg.set_context('JURISDICTION_CODE',

5051: p_jurisdiction_tab(j).emp_jd);
5052: hr_utility.trace(' Parent JD for School Dist = ' ||
5053: p_jurisdiction_tab(j).emp_parent_jd);
5054:
5055: pay_balance_pkg.set_context('JURISDICTION_CODE',
5056: p_jurisdiction_tab(j).emp_jd);
5057:
5058: lv_emp_school_jd := p_jurisdiction_tab(j).emp_jd;
5059: ln_index := get_table_index(p_jurisdiction_tab(j).emp_jd,

Line 5393: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);

5389:
5390: BEGIN
5391: hr_utility.set_location(gv_package || lv_procedure_name, 10);
5392:
5393: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
5394:
5395: /*****************************************************************
5396: ** Get Jurisdictions from pay_run_results for all locked actions
5397: ** actions of the U,P,V case and then populating different PLSQL

Line 5644: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);

5640:
5641: BEGIN
5642: hr_utility.set_location(gv_package || lv_procedure_name, 10);
5643:
5644: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
5645:
5646: open c_get_emp_adjbal(p_xfr_action_id);
5647: loop
5648: fetch c_get_emp_adjbal into ln_baladj_action_id;

Line 6709: pay_balance_pkg.set_context ('TAX_UNIT_ID',p_tax_unit_id );

6705: END IF;
6706:
6707: if l_print_wages ='Y' then
6708: null;
6709: pay_balance_pkg.set_context ('TAX_UNIT_ID',p_tax_unit_id );
6710: pay_balance_pkg.set_context ('BUSINESS_GROUP_ID',p_business_group_id );
6711: l_def_bal_id := hr_us_reports.get_defined_balance_id
6712: ('Gross Earnings','_ASG_GRE_RUN',p_business_group_id );
6713: p_wages := pay_balance_pkg.get_value(l_def_bal_id, l_run_assignment_action_id );

Line 6710: pay_balance_pkg.set_context ('BUSINESS_GROUP_ID',p_business_group_id );

6706:
6707: if l_print_wages ='Y' then
6708: null;
6709: pay_balance_pkg.set_context ('TAX_UNIT_ID',p_tax_unit_id );
6710: pay_balance_pkg.set_context ('BUSINESS_GROUP_ID',p_business_group_id );
6711: l_def_bal_id := hr_us_reports.get_defined_balance_id
6712: ('Gross Earnings','_ASG_GRE_RUN',p_business_group_id );
6713: p_wages := pay_balance_pkg.get_value(l_def_bal_id, l_run_assignment_action_id );
6714: end if;

Line 6713: p_wages := pay_balance_pkg.get_value(l_def_bal_id, l_run_assignment_action_id );

6709: pay_balance_pkg.set_context ('TAX_UNIT_ID',p_tax_unit_id );
6710: pay_balance_pkg.set_context ('BUSINESS_GROUP_ID',p_business_group_id );
6711: l_def_bal_id := hr_us_reports.get_defined_balance_id
6712: ('Gross Earnings','_ASG_GRE_RUN',p_business_group_id );
6713: p_wages := pay_balance_pkg.get_value(l_def_bal_id, l_run_assignment_action_id );
6714: end if;
6715:
6716: if l_print_county_name ='Y' then
6717: -- get county name

Line 7258: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);

7254: ln_business_group_id NUMBER;
7255:
7256: BEGIN
7257: hr_utility.set_location(gv_package || lv_procedure_name, 10);
7258: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
7259: /****************************************************************
7260: ** For Seperate Check we do the YTD balance calls with the Run
7261: ** Action ID. So, we do not need to get the max. action which is
7262: ** not seperate Check.

Line 8108: ln_earnings := nvl(pay_balance_pkg.get_value(

8104: if c_all_runs%notfound then
8105: exit;
8106: end if;
8107:
8108: ln_earnings := nvl(pay_balance_pkg.get_value(
8109: gn_gross_earn_def_bal_id,
8110: ln_all_run_asg_act_id),0);
8111:
8112: /**************************************************

Line 8121: ln_earnings := nvl(pay_balance_pkg.get_value(

8117:
8118: if ln_earnings = 0 then
8119:
8120: ln_step := 20;
8121: ln_earnings := nvl(pay_balance_pkg.get_value(
8122: gn_payments_def_bal_id,
8123: ln_all_run_asg_act_id),0);
8124:
8125: end if;