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

Line 17: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;

13: g_tax_district_reference VARCHAR2(3);
14: g_asg_set_id hr_assignment_sets.assignment_set_id%type;
15: g_context_id number;
16: g_tax_reference_number VARCHAR2(10); --4011263: length 10 chars
17: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
18: g_nia_id pay_defined_balances.defined_balance_id%TYPE;
19: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
20: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
21: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 18: g_nia_id pay_defined_balances.defined_balance_id%TYPE;

14: g_asg_set_id hr_assignment_sets.assignment_set_id%type;
15: g_context_id number;
16: g_tax_reference_number VARCHAR2(10); --4011263: length 10 chars
17: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
18: g_nia_id pay_defined_balances.defined_balance_id%TYPE;
19: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
20: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
21: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
22: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 19: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;

15: g_context_id number;
16: g_tax_reference_number VARCHAR2(10); --4011263: length 10 chars
17: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
18: g_nia_id pay_defined_balances.defined_balance_id%TYPE;
19: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
20: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
21: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
22: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
23: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 20: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;

16: g_tax_reference_number VARCHAR2(10); --4011263: length 10 chars
17: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
18: g_nia_id pay_defined_balances.defined_balance_id%TYPE;
19: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
20: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
21: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
22: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
23: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
24: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 21: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;

17: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
18: g_nia_id pay_defined_balances.defined_balance_id%TYPE;
19: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
20: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
21: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
22: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
23: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
24: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
25: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;

Line 22: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

18: g_nia_id pay_defined_balances.defined_balance_id%TYPE;
19: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
20: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
21: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
22: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
23: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
24: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
25: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
26: g_nib_id pay_defined_balances.defined_balance_id%TYPE;

Line 23: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

19: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
20: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
21: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
22: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
23: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
24: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
25: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
26: g_nib_id pay_defined_balances.defined_balance_id%TYPE;
27: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 24: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;

20: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
21: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
22: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
23: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
24: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
25: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
26: g_nib_id pay_defined_balances.defined_balance_id%TYPE;
27: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
28: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 25: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;

21: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
22: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
23: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
24: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
25: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
26: g_nib_id pay_defined_balances.defined_balance_id%TYPE;
27: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
28: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
29: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 26: g_nib_id pay_defined_balances.defined_balance_id%TYPE;

22: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
23: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
24: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
25: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
26: g_nib_id pay_defined_balances.defined_balance_id%TYPE;
27: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
28: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
29: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
30: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 27: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;

23: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
24: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
25: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
26: g_nib_id pay_defined_balances.defined_balance_id%TYPE;
27: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
28: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
29: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
30: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
31: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 28: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;

24: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
25: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
26: g_nib_id pay_defined_balances.defined_balance_id%TYPE;
27: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
28: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
29: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
30: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
31: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
32: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 29: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;

25: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
26: g_nib_id pay_defined_balances.defined_balance_id%TYPE;
27: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
28: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
29: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
30: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
31: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
32: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;

Line 30: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

26: g_nib_id pay_defined_balances.defined_balance_id%TYPE;
27: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
28: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
29: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
30: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
31: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
32: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 31: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

27: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
28: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
29: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
30: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
31: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
32: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 32: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;

28: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
29: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
30: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
31: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
32: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 33: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;

29: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
30: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
31: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
32: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 34: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;

30: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
31: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
32: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
38: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 35: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;

31: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
32: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
38: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
39: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 36: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;

32: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
38: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
39: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

Line 37: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

33: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
38: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
39: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;

Line 38: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

34: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
38: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
39: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_id pay_defined_balances.defined_balance_id%TYPE;

Line 39: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;

35: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
38: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
39: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 40: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

36: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
38: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
39: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
44: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 41: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;

37: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
38: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
39: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
44: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 42: g_nid_id pay_defined_balances.defined_balance_id%TYPE;

38: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
39: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
44: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 43: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;

39: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
44: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
47: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 44: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;

40: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
44: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
47: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
48: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 45: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;

41: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
44: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
47: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
48: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

Line 46: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

42: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
44: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
47: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
48: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;

Line 47: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

43: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
44: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
47: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
48: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;

Line 48: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;

44: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
47: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
48: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;

Line 49: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

45: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
47: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
48: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_id pay_defined_balances.defined_balance_id%TYPE;

Line 50: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;

46: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
47: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
48: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 51: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;

47: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
48: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 52: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;

48: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 53: g_nie_id pay_defined_balances.defined_balance_id%TYPE;

49: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 54: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;

50: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
58: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 55: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;

51: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
58: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
59: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 56: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;

52: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
58: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
59: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

Line 57: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

53: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
58: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
59: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
61: /* EOY 2012/2013 changes */

Line 58: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

54: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
58: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
59: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
61: /* EOY 2012/2013 changes */
62: --g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 59: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;

55: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
58: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
59: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
61: /* EOY 2012/2013 changes */
62: --g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: --g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;

Line 60: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

56: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
58: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
59: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
61: /* EOY 2012/2013 changes */
62: --g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: --g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
64: --g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 62: --g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;

58: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
59: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
61: /* EOY 2012/2013 changes */
62: --g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: --g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
64: --g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: --g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: /* EOY 2012/2013 changes */

Line 63: --g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;

59: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
61: /* EOY 2012/2013 changes */
62: --g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: --g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
64: --g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: --g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: /* EOY 2012/2013 changes */
67: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;

Line 64: --g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;

60: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
61: /* EOY 2012/2013 changes */
62: --g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: --g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
64: --g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: --g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: /* EOY 2012/2013 changes */
67: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nij_id pay_defined_balances.defined_balance_id%TYPE;

Line 65: --g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;

61: /* EOY 2012/2013 changes */
62: --g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: --g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
64: --g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: --g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: /* EOY 2012/2013 changes */
67: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 67: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;

63: --g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
64: --g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: --g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: /* EOY 2012/2013 changes */
67: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 68: g_nij_id pay_defined_balances.defined_balance_id%TYPE;

64: --g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: --g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: /* EOY 2012/2013 changes */
67: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 69: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;

65: --g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: /* EOY 2012/2013 changes */
67: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
73: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 70: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;

66: /* EOY 2012/2013 changes */
67: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
73: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
74: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 71: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;

67: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
73: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
74: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;

Line 72: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

68: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
73: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
74: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nil_id pay_defined_balances.defined_balance_id%TYPE;

Line 73: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

69: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
73: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
74: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 74: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;

70: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
73: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
74: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 75: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;

71: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
73: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
74: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 76: g_nil_id pay_defined_balances.defined_balance_id%TYPE;

72: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
73: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
74: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
80: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 77: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;

73: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
74: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
80: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
81: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 78: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;

74: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
80: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
81: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
82: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 79: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;

75: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
80: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
81: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
82: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;

Line 80: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

76: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
80: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
81: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
82: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
84: g_smp_id pay_defined_balances.defined_balance_id%TYPE;

Line 81: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

77: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
80: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
81: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
82: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
84: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
85: g_sap_id pay_defined_balances.defined_balance_id%TYPE;

Line 82: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;

78: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
80: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
81: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
82: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
84: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
85: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
86: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

Line 83: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;

79: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
80: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
81: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
82: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
84: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
85: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
86: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
87: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;

Line 84: g_smp_id pay_defined_balances.defined_balance_id%TYPE;

80: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
81: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
82: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
84: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
85: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
86: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
87: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
88: -- EOY Changes 2011/12

Line 85: g_sap_id pay_defined_balances.defined_balance_id%TYPE;

81: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
82: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
84: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
85: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
86: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
87: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
88: -- EOY Changes 2011/12
89: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

Line 86: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

82: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
84: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
85: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
86: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
87: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
88: -- EOY Changes 2011/12
89: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
90: g_aspp_birth_id pay_defined_balances.defined_balance_id%TYPE;

Line 87: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;

83: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
84: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
85: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
86: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
87: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
88: -- EOY Changes 2011/12
89: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
90: g_aspp_birth_id pay_defined_balances.defined_balance_id%TYPE;
91: --

Line 89: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

85: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
86: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
87: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
88: -- EOY Changes 2011/12
89: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
90: g_aspp_birth_id pay_defined_balances.defined_balance_id%TYPE;
91: --
92: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
93: g_notional_id pay_defined_balances.defined_balance_id%TYPE;

Line 90: g_aspp_birth_id pay_defined_balances.defined_balance_id%TYPE;

86: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
87: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
88: -- EOY Changes 2011/12
89: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
90: g_aspp_birth_id pay_defined_balances.defined_balance_id%TYPE;
91: --
92: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
93: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
94: g_paye_id pay_defined_balances.defined_balance_id%TYPE;

Line 92: g_gross_id pay_defined_balances.defined_balance_id%TYPE;

88: -- EOY Changes 2011/12
89: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
90: g_aspp_birth_id pay_defined_balances.defined_balance_id%TYPE;
91: --
92: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
93: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
94: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
95: g_super_id pay_defined_balances.defined_balance_id%TYPE;
96: g_widow_id pay_defined_balances.defined_balance_id%TYPE;

Line 93: g_notional_id pay_defined_balances.defined_balance_id%TYPE;

89: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
90: g_aspp_birth_id pay_defined_balances.defined_balance_id%TYPE;
91: --
92: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
93: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
94: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
95: g_super_id pay_defined_balances.defined_balance_id%TYPE;
96: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
97: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;

Line 94: g_paye_id pay_defined_balances.defined_balance_id%TYPE;

90: g_aspp_birth_id pay_defined_balances.defined_balance_id%TYPE;
91: --
92: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
93: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
94: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
95: g_super_id pay_defined_balances.defined_balance_id%TYPE;
96: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
97: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
98: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;

Line 95: g_super_id pay_defined_balances.defined_balance_id%TYPE;

91: --
92: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
93: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
94: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
95: g_super_id pay_defined_balances.defined_balance_id%TYPE;
96: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
97: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
98: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
99: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;

Line 96: g_widow_id pay_defined_balances.defined_balance_id%TYPE;

92: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
93: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
94: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
95: g_super_id pay_defined_balances.defined_balance_id%TYPE;
96: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
97: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
98: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
99: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;
100: g_paye_details_id pay_element_types_f.element_type_id%TYPE;

Line 97: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;

93: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
94: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
95: g_super_id pay_defined_balances.defined_balance_id%TYPE;
96: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
97: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
98: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
99: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;
100: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
101: g_paye_element_id pay_element_types_f.element_type_id%TYPE;

Line 98: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;

94: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
95: g_super_id pay_defined_balances.defined_balance_id%TYPE;
96: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
97: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
98: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
99: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;
100: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
101: g_paye_element_id pay_element_types_f.element_type_id%TYPE;
102: g_ni_id pay_element_types_f.element_type_id%TYPE;

Line 99: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;

95: g_super_id pay_defined_balances.defined_balance_id%TYPE;
96: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
97: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
98: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
99: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;
100: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
101: g_paye_element_id pay_element_types_f.element_type_id%TYPE;
102: g_ni_id pay_element_types_f.element_type_id%TYPE;
103: g_category_input_id pay_input_values_f.input_value_id%TYPE;

Line 2262: FROM pay_defined_balances db,

2258: -- get the defined balance id for specified balance and dimension
2259: cursor get_defined_balance_id
2260: (p_balance_name VARCHAR2, p_dimension_name VARCHAR2) IS
2261: SELECT defined_balance_id
2262: FROM pay_defined_balances db,
2263: pay_balance_types b,
2264: pay_balance_dimensions d
2265: WHERE b.balance_name = p_balance_name
2266: AND d.dimension_name = p_dimension_name