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_FR_ARC_PKG dependencies on PAY_DEFINED_BALANCES

Line 24: g_1total_gross_pay_db pay_defined_balances.defined_balance_id%TYPE;

20: --
21: --
22: -- Global Defined Balance IDs
23: --
24: g_1total_gross_pay_db pay_defined_balances.defined_balance_id%TYPE;
25: g_2ss_ceiling_db pay_defined_balances.defined_balance_id%TYPE;
26: g_3es_total_contributions_db pay_defined_balances.defined_balance_id%TYPE;
27: g_4statutory_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
28: g_5conventional_er_charges_db pay_defined_balances.defined_balance_id%TYPE;

Line 25: g_2ss_ceiling_db pay_defined_balances.defined_balance_id%TYPE;

21: --
22: -- Global Defined Balance IDs
23: --
24: g_1total_gross_pay_db pay_defined_balances.defined_balance_id%TYPE;
25: g_2ss_ceiling_db pay_defined_balances.defined_balance_id%TYPE;
26: g_3es_total_contributions_db pay_defined_balances.defined_balance_id%TYPE;
27: g_4statutory_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
28: g_5conventional_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
29: g_6t1_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;

Line 26: g_3es_total_contributions_db pay_defined_balances.defined_balance_id%TYPE;

22: -- Global Defined Balance IDs
23: --
24: g_1total_gross_pay_db pay_defined_balances.defined_balance_id%TYPE;
25: g_2ss_ceiling_db pay_defined_balances.defined_balance_id%TYPE;
26: g_3es_total_contributions_db pay_defined_balances.defined_balance_id%TYPE;
27: g_4statutory_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
28: g_5conventional_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
29: g_6t1_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
30: g_7t2_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;

Line 27: g_4statutory_er_charges_db pay_defined_balances.defined_balance_id%TYPE;

23: --
24: g_1total_gross_pay_db pay_defined_balances.defined_balance_id%TYPE;
25: g_2ss_ceiling_db pay_defined_balances.defined_balance_id%TYPE;
26: g_3es_total_contributions_db pay_defined_balances.defined_balance_id%TYPE;
27: g_4statutory_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
28: g_5conventional_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
29: g_6t1_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
30: g_7t2_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
31: g_8tb_argic_band_db pay_defined_balances.defined_balance_id%TYPE;

Line 28: g_5conventional_er_charges_db pay_defined_balances.defined_balance_id%TYPE;

24: g_1total_gross_pay_db pay_defined_balances.defined_balance_id%TYPE;
25: g_2ss_ceiling_db pay_defined_balances.defined_balance_id%TYPE;
26: g_3es_total_contributions_db pay_defined_balances.defined_balance_id%TYPE;
27: g_4statutory_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
28: g_5conventional_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
29: g_6t1_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
30: g_7t2_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
31: g_8tb_argic_band_db pay_defined_balances.defined_balance_id%TYPE;
32: g_9tc_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;

Line 29: g_6t1_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;

25: g_2ss_ceiling_db pay_defined_balances.defined_balance_id%TYPE;
26: g_3es_total_contributions_db pay_defined_balances.defined_balance_id%TYPE;
27: g_4statutory_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
28: g_5conventional_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
29: g_6t1_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
30: g_7t2_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
31: g_8tb_argic_band_db pay_defined_balances.defined_balance_id%TYPE;
32: g_9tc_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
33: g_10gmp_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;

Line 30: g_7t2_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;

26: g_3es_total_contributions_db pay_defined_balances.defined_balance_id%TYPE;
27: g_4statutory_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
28: g_5conventional_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
29: g_6t1_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
30: g_7t2_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
31: g_8tb_argic_band_db pay_defined_balances.defined_balance_id%TYPE;
32: g_9tc_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
33: g_10gmp_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
34: g_11total_cost_to_employer_db pay_defined_balances.defined_balance_id%TYPE;

Line 31: g_8tb_argic_band_db pay_defined_balances.defined_balance_id%TYPE;

27: g_4statutory_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
28: g_5conventional_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
29: g_6t1_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
30: g_7t2_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
31: g_8tb_argic_band_db pay_defined_balances.defined_balance_id%TYPE;
32: g_9tc_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
33: g_10gmp_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
34: g_11total_cost_to_employer_db pay_defined_balances.defined_balance_id%TYPE;
35: g_12taxable_income_db pay_defined_balances.defined_balance_id%TYPE;

Line 32: g_9tc_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;

28: g_5conventional_er_charges_db pay_defined_balances.defined_balance_id%TYPE;
29: g_6t1_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
30: g_7t2_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
31: g_8tb_argic_band_db pay_defined_balances.defined_balance_id%TYPE;
32: g_9tc_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
33: g_10gmp_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
34: g_11total_cost_to_employer_db pay_defined_balances.defined_balance_id%TYPE;
35: g_12taxable_income_db pay_defined_balances.defined_balance_id%TYPE;
36: --

Line 33: g_10gmp_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;

29: g_6t1_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
30: g_7t2_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
31: g_8tb_argic_band_db pay_defined_balances.defined_balance_id%TYPE;
32: g_9tc_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
33: g_10gmp_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
34: g_11total_cost_to_employer_db pay_defined_balances.defined_balance_id%TYPE;
35: g_12taxable_income_db pay_defined_balances.defined_balance_id%TYPE;
36: --
37: -- Global dimension IDs

Line 34: g_11total_cost_to_employer_db pay_defined_balances.defined_balance_id%TYPE;

30: g_7t2_arrco_band_db pay_defined_balances.defined_balance_id%TYPE;
31: g_8tb_argic_band_db pay_defined_balances.defined_balance_id%TYPE;
32: g_9tc_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
33: g_10gmp_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
34: g_11total_cost_to_employer_db pay_defined_balances.defined_balance_id%TYPE;
35: g_12taxable_income_db pay_defined_balances.defined_balance_id%TYPE;
36: --
37: -- Global dimension IDs
38: --

Line 35: g_12taxable_income_db pay_defined_balances.defined_balance_id%TYPE;

31: g_8tb_argic_band_db pay_defined_balances.defined_balance_id%TYPE;
32: g_9tc_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
33: g_10gmp_agirc_band_db pay_defined_balances.defined_balance_id%TYPE;
34: g_11total_cost_to_employer_db pay_defined_balances.defined_balance_id%TYPE;
35: g_12taxable_income_db pay_defined_balances.defined_balance_id%TYPE;
36: --
37: -- Global dimension IDs
38: --
39: g_asg_run pay_defined_balances.balance_dimension_id%TYPE;

Line 39: g_asg_run pay_defined_balances.balance_dimension_id%TYPE;

35: g_12taxable_income_db pay_defined_balances.defined_balance_id%TYPE;
36: --
37: -- Global dimension IDs
38: --
39: g_asg_run pay_defined_balances.balance_dimension_id%TYPE;
40: g_asg_pro_run pay_defined_balances.balance_dimension_id%TYPE;
41: g_asg_et_pr_ra_cu_run pay_defined_balances.balance_dimension_id%TYPE;
42: g_asg_et_pr_ra_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;
43: g_asg_et_pr_cu_run pay_defined_balances.balance_dimension_id%TYPE;

Line 40: g_asg_pro_run pay_defined_balances.balance_dimension_id%TYPE;

36: --
37: -- Global dimension IDs
38: --
39: g_asg_run pay_defined_balances.balance_dimension_id%TYPE;
40: g_asg_pro_run pay_defined_balances.balance_dimension_id%TYPE;
41: g_asg_et_pr_ra_cu_run pay_defined_balances.balance_dimension_id%TYPE;
42: g_asg_et_pr_ra_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;
43: g_asg_et_pr_cu_run pay_defined_balances.balance_dimension_id%TYPE;
44: g_asg_et_pr_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;

Line 41: g_asg_et_pr_ra_cu_run pay_defined_balances.balance_dimension_id%TYPE;

37: -- Global dimension IDs
38: --
39: g_asg_run pay_defined_balances.balance_dimension_id%TYPE;
40: g_asg_pro_run pay_defined_balances.balance_dimension_id%TYPE;
41: g_asg_et_pr_ra_cu_run pay_defined_balances.balance_dimension_id%TYPE;
42: g_asg_et_pr_ra_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;
43: g_asg_et_pr_cu_run pay_defined_balances.balance_dimension_id%TYPE;
44: g_asg_et_pr_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;
45: --

Line 42: g_asg_et_pr_ra_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;

38: --
39: g_asg_run pay_defined_balances.balance_dimension_id%TYPE;
40: g_asg_pro_run pay_defined_balances.balance_dimension_id%TYPE;
41: g_asg_et_pr_ra_cu_run pay_defined_balances.balance_dimension_id%TYPE;
42: g_asg_et_pr_ra_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;
43: g_asg_et_pr_cu_run pay_defined_balances.balance_dimension_id%TYPE;
44: g_asg_et_pr_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;
45: --
46: -- global totals contexts (holds lookup codes to get meanings)

Line 43: g_asg_et_pr_cu_run pay_defined_balances.balance_dimension_id%TYPE;

39: g_asg_run pay_defined_balances.balance_dimension_id%TYPE;
40: g_asg_pro_run pay_defined_balances.balance_dimension_id%TYPE;
41: g_asg_et_pr_ra_cu_run pay_defined_balances.balance_dimension_id%TYPE;
42: g_asg_et_pr_ra_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;
43: g_asg_et_pr_cu_run pay_defined_balances.balance_dimension_id%TYPE;
44: g_asg_et_pr_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;
45: --
46: -- global totals contexts (holds lookup codes to get meanings)
47: --

Line 44: g_asg_et_pr_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;

40: g_asg_pro_run pay_defined_balances.balance_dimension_id%TYPE;
41: g_asg_et_pr_ra_cu_run pay_defined_balances.balance_dimension_id%TYPE;
42: g_asg_et_pr_ra_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;
43: g_asg_et_pr_cu_run pay_defined_balances.balance_dimension_id%TYPE;
44: g_asg_et_pr_cu_pro_run pay_defined_balances.balance_dimension_id%TYPE;
45: --
46: -- global totals contexts (holds lookup codes to get meanings)
47: --
48: g_totals_c1_total_gross varchar2(30) := 'TOTAL_GROSS';

Line 3270: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

3266: function get_balance_id (
3267: p_balance_name in varchar2
3268: ,p_dimension in varchar2) RETURN number is
3269: --
3270: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
3271: --
3272: l_proc VARCHAR2(40):= g_package||' get_balance_id ';
3273: --
3274: BEGIN

Line 3279: FROM pay_defined_balances db

3275: --
3276: hr_utility.set_location('Entering ' || l_proc, 10);
3277: SELECT defined_balance_id
3278: INTO l_defined_balance_id
3279: FROM pay_defined_balances db
3280: ,pay_balance_types b
3281: ,pay_balance_dimensions d
3282: WHERE b.balance_name = p_balance_name
3283: AND d.dimension_name = p_dimension

Line 3424: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

3420: l_action_info_id pay_action_information.action_information_id%TYPE;
3421: l_ovn pay_action_information.object_version_number%TYPE;
3422: l_archive_type varchar2(3) := 'AAP';
3423: l_group_code fnd_lookup_values.lookup_code%TYPE;
3424: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
3425: l_rubric fnd_lookup_values.tag%TYPE;
3426: l_description fnd_lookup_values.meaning%TYPE;
3427: l_retro_tl fnd_lookup_values.meaning%TYPE;
3428: --

Line 3453: , pay_defined_balances db

3449: from pay_action_interlocks arclck
3450: , pay_action_interlocks prelck
3451: , pay_balance_types b
3452: , pay_run_balances rb
3453: , pay_defined_balances db
3454: , pay_payroll_actions pa
3455: , pay_assignment_actions aa
3456: , pay_defined_balances db2
3457: , pay_fr_contribution_usages fcu

Line 3456: , pay_defined_balances db2

3452: , pay_run_balances rb
3453: , pay_defined_balances db
3454: , pay_payroll_actions pa
3455: , pay_assignment_actions aa
3456: , pay_defined_balances db2
3457: , pay_fr_contribution_usages fcu
3458: , pay_input_values_f piv
3459: , pay_element_types_f pet
3460: where arclck.locking_action_id = p_archive_assignment_action_id

Line 3475: from pay_defined_balances db1

3471: and db.balance_dimension_id in (g_asg_et_pr_ra_cu_run
3472: ,g_asg_et_pr_cu_run
3473: ,g_asg_run)
3474: and (db.balance_dimension_id <> g_asg_run or not exists (select 1
3475: from pay_defined_balances db1
3476: where db1.balance_type_id = db.balance_type_id
3477: and db1.balance_dimension_id in (g_asg_et_pr_ra_cu_run
3478: ,g_asg_et_pr_cu_run)))
3479: and rb.defined_balance_id = db.defined_balance_id