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

Line 53: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;

49: g_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni normal balances
50: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances
51: --
52:
53: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 54: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;

50: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances
51: --
52:
53: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 55: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;

51: --
52:
53: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
59:

Line 56: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;

52:
53: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
59:
60: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 57: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

53: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
59:
60: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 58: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

54: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
59:
60: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;

Line 60: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;

56: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
59:
60: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 61: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;

57: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
59:
60: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 62: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;

58: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
59:
60: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
66:

Line 63: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;

59:
60: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
66:
67: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 64: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

60: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
66:
67: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 65: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

61: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
66:
67: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;

Line 67: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;

63: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
66:
67: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 68: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;

64: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
66:
67: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 69: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;

65: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
66:
67: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
73:

Line 70: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;

66:
67: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
73:
74: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 71: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

67: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
73:
74: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 72: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

68: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
73:
74: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;

Line 74: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;

70: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
73:
74: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 75: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;

71: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
73:
74: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 76: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;

72: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
73:
74: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
80:

Line 77: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;

73:
74: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
80:
81: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 78: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

74: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
80:
81: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 79: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

75: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
80:
81: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;

Line 81: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;

77: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
80:
81: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
85: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 82: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;

78: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
80:
81: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
85: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 83: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;

79: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
80:
81: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
85: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
87:

Line 84: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;

80:
81: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
85: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
87:
88: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 85: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

81: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
85: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
87:
88: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 86: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

82: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
85: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
87:
88: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;

Line 88: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;

84: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
85: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
87:
88: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 89: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;

85: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
87:
88: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
93: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 90: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;

86: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
87:
88: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
93: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
94:

Line 91: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;

87:
88: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
93: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
94:
95: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 92: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

88: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
93: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
94:
95: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 93: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

89: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
93: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
94:
95: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
97: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;

Line 95: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;

91: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
93: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
94:
95: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
97: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 96: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;

92: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
93: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
94:
95: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
97: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 97: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;

93: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
94:
95: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
97: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
101:

Line 98: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;

94:
95: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
97: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
101:
102: --Aggr details

Line 99: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

95: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
97: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
101:
102: --Aggr details
103:

Line 100: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

96: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
97: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
101:
102: --Aggr details
103:
104: g_per_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 104: g_per_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;

100: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
101:
102: --Aggr details
103:
104: g_per_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
105: g_per_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
106: g_per_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;
107: g_per_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
108: g_per_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 105: g_per_nia_et_id pay_defined_balances.defined_balance_id%TYPE;

101:
102: --Aggr details
103:
104: g_per_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
105: g_per_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
106: g_per_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;
107: g_per_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
108: g_per_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_per_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 106: g_per_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;

102: --Aggr details
103:
104: g_per_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
105: g_per_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
106: g_per_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;
107: g_per_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
108: g_per_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_per_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110:

Line 107: g_per_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;

103:
104: g_per_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
105: g_per_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
106: g_per_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;
107: g_per_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
108: g_per_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_per_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110:
111: g_per_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 108: g_per_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

104: g_per_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
105: g_per_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
106: g_per_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;
107: g_per_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
108: g_per_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_per_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110:
111: g_per_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
112: g_per_nib_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 109: g_per_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

105: g_per_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
106: g_per_nia_uap_id pay_defined_balances.defined_balance_id%TYPE;
107: g_per_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
108: g_per_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_per_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110:
111: g_per_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
112: g_per_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
113: g_per_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;

Line 111: g_per_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;

107: g_per_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
108: g_per_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_per_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110:
111: g_per_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
112: g_per_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
113: g_per_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;
114: g_per_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
115: g_per_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 112: g_per_nib_et_id pay_defined_balances.defined_balance_id%TYPE;

108: g_per_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_per_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110:
111: g_per_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
112: g_per_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
113: g_per_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;
114: g_per_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
115: g_per_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_per_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 113: g_per_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;

109: g_per_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110:
111: g_per_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
112: g_per_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
113: g_per_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;
114: g_per_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
115: g_per_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_per_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
117:

Line 114: g_per_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;

110:
111: g_per_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
112: g_per_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
113: g_per_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;
114: g_per_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
115: g_per_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_per_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
117:
118: g_per_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 115: g_per_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

111: g_per_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
112: g_per_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
113: g_per_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;
114: g_per_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
115: g_per_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_per_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
117:
118: g_per_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
119: g_per_nic_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 116: g_per_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

112: g_per_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
113: g_per_nib_uap_id pay_defined_balances.defined_balance_id%TYPE;
114: g_per_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
115: g_per_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_per_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
117:
118: g_per_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
119: g_per_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
120: g_per_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;

Line 118: g_per_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;

114: g_per_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
115: g_per_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_per_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
117:
118: g_per_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
119: g_per_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
120: g_per_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;
121: g_per_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
122: g_per_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 119: g_per_nic_et_id pay_defined_balances.defined_balance_id%TYPE;

115: g_per_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_per_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
117:
118: g_per_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
119: g_per_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
120: g_per_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;
121: g_per_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
122: g_per_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_per_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 120: g_per_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;

116: g_per_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
117:
118: g_per_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
119: g_per_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
120: g_per_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;
121: g_per_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
122: g_per_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_per_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124:

Line 121: g_per_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;

117:
118: g_per_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
119: g_per_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
120: g_per_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;
121: g_per_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
122: g_per_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_per_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124:
125: g_per_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 122: g_per_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

118: g_per_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
119: g_per_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
120: g_per_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;
121: g_per_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
122: g_per_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_per_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124:
125: g_per_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
126: g_per_nid_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 123: g_per_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

119: g_per_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
120: g_per_nic_uap_id pay_defined_balances.defined_balance_id%TYPE;
121: g_per_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
122: g_per_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_per_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124:
125: g_per_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
126: g_per_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
127: g_per_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;

Line 125: g_per_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;

121: g_per_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
122: g_per_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_per_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124:
125: g_per_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
126: g_per_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
127: g_per_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;
128: g_per_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_per_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 126: g_per_nid_et_id pay_defined_balances.defined_balance_id%TYPE;

122: g_per_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_per_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124:
125: g_per_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
126: g_per_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
127: g_per_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;
128: g_per_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_per_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
130: g_per_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 127: g_per_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;

123: g_per_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124:
125: g_per_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
126: g_per_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
127: g_per_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;
128: g_per_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_per_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
130: g_per_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
131:

Line 128: g_per_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;

124:
125: g_per_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
126: g_per_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
127: g_per_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;
128: g_per_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_per_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
130: g_per_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
131:
132: g_per_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 129: g_per_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

125: g_per_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
126: g_per_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
127: g_per_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;
128: g_per_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_per_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
130: g_per_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
131:
132: g_per_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
133: g_per_nie_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 130: g_per_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

126: g_per_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
127: g_per_nid_uap_id pay_defined_balances.defined_balance_id%TYPE;
128: g_per_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_per_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
130: g_per_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
131:
132: g_per_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
133: g_per_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
134: g_per_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;

Line 132: g_per_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;

128: g_per_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_per_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
130: g_per_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
131:
132: g_per_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
133: g_per_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
134: g_per_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;
135: g_per_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
136: g_per_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 133: g_per_nie_et_id pay_defined_balances.defined_balance_id%TYPE;

129: g_per_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
130: g_per_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
131:
132: g_per_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
133: g_per_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
134: g_per_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;
135: g_per_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
136: g_per_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_per_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 134: g_per_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;

130: g_per_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
131:
132: g_per_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
133: g_per_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
134: g_per_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;
135: g_per_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
136: g_per_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_per_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
138:

Line 135: g_per_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;

131:
132: g_per_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
133: g_per_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
134: g_per_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;
135: g_per_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
136: g_per_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_per_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
138:
139: g_per_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 136: g_per_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

132: g_per_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
133: g_per_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
134: g_per_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;
135: g_per_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
136: g_per_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_per_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
138:
139: g_per_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
140: g_per_nij_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 137: g_per_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

133: g_per_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
134: g_per_nie_uap_id pay_defined_balances.defined_balance_id%TYPE;
135: g_per_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
136: g_per_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_per_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
138:
139: g_per_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
140: g_per_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
141: g_per_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;

Line 139: g_per_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;

135: g_per_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
136: g_per_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_per_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
138:
139: g_per_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
140: g_per_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
141: g_per_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;
142: g_per_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
143: g_per_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 140: g_per_nij_et_id pay_defined_balances.defined_balance_id%TYPE;

136: g_per_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_per_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
138:
139: g_per_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
140: g_per_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
141: g_per_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;
142: g_per_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
143: g_per_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_per_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 141: g_per_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;

137: g_per_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
138:
139: g_per_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
140: g_per_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
141: g_per_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;
142: g_per_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
143: g_per_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_per_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145:

Line 142: g_per_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;

138:
139: g_per_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
140: g_per_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
141: g_per_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;
142: g_per_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
143: g_per_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_per_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145:
146: g_per_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 143: g_per_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

139: g_per_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
140: g_per_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
141: g_per_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;
142: g_per_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
143: g_per_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_per_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145:
146: g_per_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
147: g_per_nil_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 144: g_per_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

140: g_per_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
141: g_per_nij_uap_id pay_defined_balances.defined_balance_id%TYPE;
142: g_per_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
143: g_per_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_per_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145:
146: g_per_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
147: g_per_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
148: g_per_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;

Line 146: g_per_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;

142: g_per_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
143: g_per_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_per_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145:
146: g_per_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
147: g_per_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
148: g_per_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;
149: g_per_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
150: g_per_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 147: g_per_nil_et_id pay_defined_balances.defined_balance_id%TYPE;

143: g_per_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_per_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145:
146: g_per_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
147: g_per_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
148: g_per_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;
149: g_per_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
150: g_per_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_per_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 148: g_per_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;

144: g_per_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145:
146: g_per_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
147: g_per_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
148: g_per_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;
149: g_per_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
150: g_per_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_per_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
152:

Line 149: g_per_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;

145:
146: g_per_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
147: g_per_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
148: g_per_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;
149: g_per_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
150: g_per_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_per_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
152:
153: -- NI Run balance fields

Line 150: g_per_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

146: g_per_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
147: g_per_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
148: g_per_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;
149: g_per_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
150: g_per_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_per_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
152:
153: -- NI Run balance fields
154: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 151: g_per_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

147: g_per_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
148: g_per_nil_uap_id pay_defined_balances.defined_balance_id%TYPE;
149: g_per_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
150: g_per_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_per_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
152:
153: -- NI Run balance fields
154: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
155: g_nia_e_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 154: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;

150: g_per_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_per_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
152:
153: -- NI Run balance fields
154: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
155: g_nia_e_id_run pay_defined_balances.defined_balance_id%TYPE;
156: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
157: g_nib_e_id_run pay_defined_balances.defined_balance_id%TYPE;
158: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 155: g_nia_e_id_run pay_defined_balances.defined_balance_id%TYPE;

151: g_per_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
152:
153: -- NI Run balance fields
154: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
155: g_nia_e_id_run pay_defined_balances.defined_balance_id%TYPE;
156: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
157: g_nib_e_id_run pay_defined_balances.defined_balance_id%TYPE;
158: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
159: g_nic_e_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 156: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;

152:
153: -- NI Run balance fields
154: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
155: g_nia_e_id_run pay_defined_balances.defined_balance_id%TYPE;
156: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
157: g_nib_e_id_run pay_defined_balances.defined_balance_id%TYPE;
158: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
159: g_nic_e_id_run pay_defined_balances.defined_balance_id%TYPE;
160: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 157: g_nib_e_id_run pay_defined_balances.defined_balance_id%TYPE;

153: -- NI Run balance fields
154: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
155: g_nia_e_id_run pay_defined_balances.defined_balance_id%TYPE;
156: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
157: g_nib_e_id_run pay_defined_balances.defined_balance_id%TYPE;
158: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
159: g_nic_e_id_run pay_defined_balances.defined_balance_id%TYPE;
160: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
161: g_nid_e_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 158: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;

154: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
155: g_nia_e_id_run pay_defined_balances.defined_balance_id%TYPE;
156: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
157: g_nib_e_id_run pay_defined_balances.defined_balance_id%TYPE;
158: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
159: g_nic_e_id_run pay_defined_balances.defined_balance_id%TYPE;
160: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
161: g_nid_e_id_run pay_defined_balances.defined_balance_id%TYPE;
162: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 159: g_nic_e_id_run pay_defined_balances.defined_balance_id%TYPE;

155: g_nia_e_id_run pay_defined_balances.defined_balance_id%TYPE;
156: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
157: g_nib_e_id_run pay_defined_balances.defined_balance_id%TYPE;
158: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
159: g_nic_e_id_run pay_defined_balances.defined_balance_id%TYPE;
160: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
161: g_nid_e_id_run pay_defined_balances.defined_balance_id%TYPE;
162: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
163: g_nie_e_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 160: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;

156: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
157: g_nib_e_id_run pay_defined_balances.defined_balance_id%TYPE;
158: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
159: g_nic_e_id_run pay_defined_balances.defined_balance_id%TYPE;
160: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
161: g_nid_e_id_run pay_defined_balances.defined_balance_id%TYPE;
162: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
163: g_nie_e_id_run pay_defined_balances.defined_balance_id%TYPE;
164: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 161: g_nid_e_id_run pay_defined_balances.defined_balance_id%TYPE;

157: g_nib_e_id_run pay_defined_balances.defined_balance_id%TYPE;
158: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
159: g_nic_e_id_run pay_defined_balances.defined_balance_id%TYPE;
160: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
161: g_nid_e_id_run pay_defined_balances.defined_balance_id%TYPE;
162: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
163: g_nie_e_id_run pay_defined_balances.defined_balance_id%TYPE;
164: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
165: g_nij_e_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 162: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;

158: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
159: g_nic_e_id_run pay_defined_balances.defined_balance_id%TYPE;
160: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
161: g_nid_e_id_run pay_defined_balances.defined_balance_id%TYPE;
162: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
163: g_nie_e_id_run pay_defined_balances.defined_balance_id%TYPE;
164: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
165: g_nij_e_id_run pay_defined_balances.defined_balance_id%TYPE;
166: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 163: g_nie_e_id_run pay_defined_balances.defined_balance_id%TYPE;

159: g_nic_e_id_run pay_defined_balances.defined_balance_id%TYPE;
160: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
161: g_nid_e_id_run pay_defined_balances.defined_balance_id%TYPE;
162: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
163: g_nie_e_id_run pay_defined_balances.defined_balance_id%TYPE;
164: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
165: g_nij_e_id_run pay_defined_balances.defined_balance_id%TYPE;
166: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
167: g_nil_e_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 164: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;

160: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
161: g_nid_e_id_run pay_defined_balances.defined_balance_id%TYPE;
162: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
163: g_nie_e_id_run pay_defined_balances.defined_balance_id%TYPE;
164: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
165: g_nij_e_id_run pay_defined_balances.defined_balance_id%TYPE;
166: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
167: g_nil_e_id_run pay_defined_balances.defined_balance_id%TYPE;
168:

Line 165: g_nij_e_id_run pay_defined_balances.defined_balance_id%TYPE;

161: g_nid_e_id_run pay_defined_balances.defined_balance_id%TYPE;
162: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
163: g_nie_e_id_run pay_defined_balances.defined_balance_id%TYPE;
164: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
165: g_nij_e_id_run pay_defined_balances.defined_balance_id%TYPE;
166: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
167: g_nil_e_id_run pay_defined_balances.defined_balance_id%TYPE;
168:
169: -- Function to fetch address details (CONTEXT - ADDRESS DETAILS)

Line 166: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;

162: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
163: g_nie_e_id_run pay_defined_balances.defined_balance_id%TYPE;
164: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
165: g_nij_e_id_run pay_defined_balances.defined_balance_id%TYPE;
166: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
167: g_nil_e_id_run pay_defined_balances.defined_balance_id%TYPE;
168:
169: -- Function to fetch address details (CONTEXT - ADDRESS DETAILS)
170: FUNCTION fetch_address_rec(

Line 167: g_nil_e_id_run pay_defined_balances.defined_balance_id%TYPE;

163: g_nie_e_id_run pay_defined_balances.defined_balance_id%TYPE;
164: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
165: g_nij_e_id_run pay_defined_balances.defined_balance_id%TYPE;
166: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
167: g_nil_e_id_run pay_defined_balances.defined_balance_id%TYPE;
168:
169: -- Function to fetch address details (CONTEXT - ADDRESS DETAILS)
170: FUNCTION fetch_address_rec(
171: p_person_id IN NUMBER,

Line 957: pay_defined_balances pdb,

953: WHERE SOURCE_ACTION_ID = c_lst_act_id;
954:
955: cursor csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
956: select pdb.defined_balance_id from
957: pay_defined_balances pdb,
958: pay_balance_dimensions pbd,
959: pay_balance_types pbt
960: where pbt.balance_name = c_balance_name
961: and pbd.database_item_suffix = c_dim_name

Line 1304: select pdb.defined_balance_id from pay_defined_balances pdb,

1300: FROM pay_assignment_actions
1301: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1302:
1303: cursor csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
1304: select pdb.defined_balance_id from pay_defined_balances pdb,
1305: pay_balance_dimensions pbd,
1306: pay_balance_types pbt
1307: where pbt.balance_name = c_balance_name
1308: and pbd.database_item_suffix = c_dim_name

Line 4630: FROM pay_defined_balances db,

4626:
4627: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
4628: IS
4629: SELECT defined_balance_id
4630: FROM pay_defined_balances db,
4631: pay_balance_types b,
4632: pay_balance_dimensions d
4633: WHERE b.balance_name = p_balance_name
4634: AND d.dimension_name = p_dimension_name

Line 4648: FROM pay_defined_balances db,

4644: b.balance_type_id balance_type_id,
4645: d.database_item_suffix database_item_suffix,
4646: d.balance_dimension_id balance_dimension_id,
4647: db.defined_balance_id defined_balance_id
4648: FROM pay_defined_balances db,
4649: pay_balance_types b,
4650: pay_balance_dimensions d
4651: WHERE db.balance_type_id = b.balance_type_id
4652: AND db.balance_dimension_id = d.balance_dimension_id

Line 4671: FROM pay_defined_balances db,

4667: b.balance_type_id balance_type_id,
4668: d.database_item_suffix database_item_suffix,
4669: d.balance_dimension_id balance_dimension_id,
4670: db.defined_balance_id defined_balance_id
4671: FROM pay_defined_balances db,
4672: pay_balance_types b,
4673: pay_balance_dimensions d
4674: WHERE db.balance_type_id = b.balance_type_id
4675: AND db.balance_dimension_id = d.balance_dimension_id

Line 4696: FROM pay_defined_balances db,

4692: b.balance_type_id balance_type_id,
4693: d.database_item_suffix database_item_suffix,
4694: d.balance_dimension_id balance_dimension_id,
4695: db.defined_balance_id defined_balance_id
4696: FROM pay_defined_balances db,
4697: pay_balance_types b,
4698: pay_balance_dimensions d
4699: WHERE db.balance_type_id = b.balance_type_id
4700: AND db.balance_dimension_id = d.balance_dimension_id

Line 4721: FROM pay_defined_balances db,

4717: b.balance_type_id balance_type_id,
4718: d.database_item_suffix database_item_suffix,
4719: d.balance_dimension_id balance_dimension_id,
4720: db.defined_balance_id defined_balance_id
4721: FROM pay_defined_balances db,
4722: pay_balance_types b,
4723: pay_balance_dimensions d
4724: WHERE db.balance_type_id = b.balance_type_id
4725: AND db.balance_dimension_id = d.balance_dimension_id