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_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

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_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
23: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;

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_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
23: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
24: g_nib_able_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_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
23: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
24: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
25: g_nib_id pay_defined_balances.defined_balance_id%TYPE;

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

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_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
23: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
24: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
25: g_nib_id pay_defined_balances.defined_balance_id%TYPE;
26: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 23: g_nia_et_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_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
23: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
24: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
25: g_nib_id pay_defined_balances.defined_balance_id%TYPE;
26: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
27: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 24: g_nib_able_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_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
23: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
24: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
25: g_nib_id pay_defined_balances.defined_balance_id%TYPE;
26: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
27: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
28: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 25: g_nib_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 26: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 27: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 28: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;

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

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

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

Line 30: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 31: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 32: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 33: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;

29: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
30: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
31: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
32: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
36: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

Line 34: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;

30: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
31: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
32: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
36: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
38: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;

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

31: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
32: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
36: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
38: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
39: g_nid_id pay_defined_balances.defined_balance_id%TYPE;

Line 36: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;

32: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
36: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
38: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
39: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 37: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

33: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
36: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
38: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
39: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 38: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;

34: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
36: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
38: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
39: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 39: g_nid_id pay_defined_balances.defined_balance_id%TYPE;

35: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
36: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
38: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
39: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 40: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;

36: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
38: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
39: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 41: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;

37: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
38: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
39: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

Line 42: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;

38: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
39: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;

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

39: g_nid_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
47: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;

Line 44: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;

40: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
47: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;

Line 45: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

41: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
47: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nie_id pay_defined_balances.defined_balance_id%TYPE;

Line 46: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;

42: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
43: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
47: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 47: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;

43: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
47: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 48: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;

44: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
47: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 49: g_nie_id pay_defined_balances.defined_balance_id%TYPE;

45: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
47: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 50: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;

46: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
47: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
54: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 51: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;

47: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
54: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

Line 52: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;

48: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
54: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;

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

49: g_nie_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
54: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;

Line 54: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;

50: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
51: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
54: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 55: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

51: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
52: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
54: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
59: g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 56: g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;

52: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
54: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
59: g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;

Line 57: g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;

53: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
54: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
59: g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nij_id pay_defined_balances.defined_balance_id%TYPE;

Line 58: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;

54: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
59: g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 59: g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;

55: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
59: g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 60: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;

56: g_nif_tot_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
59: g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 61: g_nij_id pay_defined_balances.defined_balance_id%TYPE;

57: g_nif_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
59: g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 62: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;

58: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
59: g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
66: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 63: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;

59: g_nis_tot_id pay_defined_balances.defined_balance_id%TYPE;
60: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
66: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;

Line 64: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;

60: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
66: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nil_id pay_defined_balances.defined_balance_id%TYPE;

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

61: g_nij_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
66: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 66: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;

62: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
66: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 67: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;

63: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
66: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 68: g_nil_id pay_defined_balances.defined_balance_id%TYPE;

64: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
66: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 69: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;

65: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
66: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
73: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 70: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;

66: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
73: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
74: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;

Line 71: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;

67: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
73: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
74: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
75: g_smp_id pay_defined_balances.defined_balance_id%TYPE;

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

68: g_nil_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
73: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
74: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
75: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
76: g_sap_id pay_defined_balances.defined_balance_id%TYPE;

Line 73: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;

69: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
73: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
74: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
75: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
76: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

Line 74: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;

70: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
73: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
74: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
75: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
76: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
78: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;

Line 75: g_smp_id pay_defined_balances.defined_balance_id%TYPE;

71: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
73: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
74: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
75: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
76: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
78: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
79: g_gross_id pay_defined_balances.defined_balance_id%TYPE;

Line 76: g_sap_id pay_defined_balances.defined_balance_id%TYPE;

72: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
73: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
74: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
75: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
76: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
78: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
79: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
80: g_notional_id pay_defined_balances.defined_balance_id%TYPE;

Line 77: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

73: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
74: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
75: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
76: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
78: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
79: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
80: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
81: g_paye_id pay_defined_balances.defined_balance_id%TYPE;

Line 78: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;

74: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
75: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
76: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
78: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
79: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
80: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
81: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
82: g_super_id pay_defined_balances.defined_balance_id%TYPE;

Line 79: g_gross_id pay_defined_balances.defined_balance_id%TYPE;

75: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
76: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
78: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
79: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
80: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
81: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
82: g_super_id pay_defined_balances.defined_balance_id%TYPE;
83: g_widow_id pay_defined_balances.defined_balance_id%TYPE;

Line 80: g_notional_id pay_defined_balances.defined_balance_id%TYPE;

76: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
78: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
79: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
80: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
81: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
82: g_super_id pay_defined_balances.defined_balance_id%TYPE;
83: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
84: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;

Line 81: g_paye_id pay_defined_balances.defined_balance_id%TYPE;

77: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
78: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
79: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
80: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
81: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
82: g_super_id pay_defined_balances.defined_balance_id%TYPE;
83: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
84: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
85: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;

Line 82: g_super_id pay_defined_balances.defined_balance_id%TYPE;

78: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
79: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
80: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
81: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
82: g_super_id pay_defined_balances.defined_balance_id%TYPE;
83: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
84: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
85: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
86: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;

Line 83: g_widow_id pay_defined_balances.defined_balance_id%TYPE;

79: g_gross_id pay_defined_balances.defined_balance_id%TYPE;
80: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
81: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
82: g_super_id pay_defined_balances.defined_balance_id%TYPE;
83: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
84: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
85: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
86: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;
87: g_paye_details_id pay_element_types_f.element_type_id%TYPE;

Line 84: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;

80: g_notional_id pay_defined_balances.defined_balance_id%TYPE;
81: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
82: g_super_id pay_defined_balances.defined_balance_id%TYPE;
83: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
84: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
85: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
86: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;
87: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
88: g_paye_element_id pay_element_types_f.element_type_id%TYPE;

Line 85: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;

81: g_paye_id pay_defined_balances.defined_balance_id%TYPE;
82: g_super_id pay_defined_balances.defined_balance_id%TYPE;
83: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
84: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
85: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
86: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;
87: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
88: g_paye_element_id pay_element_types_f.element_type_id%TYPE;
89: g_ni_id pay_element_types_f.element_type_id%TYPE;

Line 86: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;

82: g_super_id pay_defined_balances.defined_balance_id%TYPE;
83: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
84: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
85: g_taxable_id pay_defined_balances.defined_balance_id%TYPE;
86: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;
87: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
88: g_paye_element_id pay_element_types_f.element_type_id%TYPE;
89: g_ni_id pay_element_types_f.element_type_id%TYPE;
90: g_category_input_id pay_input_values_f.input_value_id%TYPE;

Line 2213: FROM pay_defined_balances db,

2209: -- get the defined balance id for specified balance and dimension
2210: cursor get_defined_balance_id
2211: (p_balance_name VARCHAR2, p_dimension_name VARCHAR2) IS
2212: SELECT defined_balance_id
2213: FROM pay_defined_balances db,
2214: pay_balance_types b,
2215: pay_balance_dimensions d
2216: WHERE b.balance_name = p_balance_name
2217: AND d.dimension_name = p_dimension_name