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.PQP_TIAALOD_PKG dependencies on PAY_BALANCE_TYPES

Line 74: balance_name1 pay_balance_types.balance_name%TYPE,

70: org_name hr_organization_units.name%TYPE,
71: effective_date DATE,
72: ppg_billing pay_payrolls_f.prl_information7%TYPE,
73:
74: balance_name1 pay_balance_types.balance_name%TYPE,
75: balance_value1 NUMBER,
76: balance_name2 pay_balance_types.balance_name%TYPE,
77: balance_value2 NUMBER,
78: balance_name3 pay_balance_types.balance_name%TYPE,

Line 76: balance_name2 pay_balance_types.balance_name%TYPE,

72: ppg_billing pay_payrolls_f.prl_information7%TYPE,
73:
74: balance_name1 pay_balance_types.balance_name%TYPE,
75: balance_value1 NUMBER,
76: balance_name2 pay_balance_types.balance_name%TYPE,
77: balance_value2 NUMBER,
78: balance_name3 pay_balance_types.balance_name%TYPE,
79: balance_value3 NUMBER,
80: balance_name4 pay_balance_types.balance_name%TYPE,

Line 78: balance_name3 pay_balance_types.balance_name%TYPE,

74: balance_name1 pay_balance_types.balance_name%TYPE,
75: balance_value1 NUMBER,
76: balance_name2 pay_balance_types.balance_name%TYPE,
77: balance_value2 NUMBER,
78: balance_name3 pay_balance_types.balance_name%TYPE,
79: balance_value3 NUMBER,
80: balance_name4 pay_balance_types.balance_name%TYPE,
81: balance_value4 NUMBER,
82: balance_name5 pay_balance_types.balance_name%TYPE,

Line 80: balance_name4 pay_balance_types.balance_name%TYPE,

76: balance_name2 pay_balance_types.balance_name%TYPE,
77: balance_value2 NUMBER,
78: balance_name3 pay_balance_types.balance_name%TYPE,
79: balance_value3 NUMBER,
80: balance_name4 pay_balance_types.balance_name%TYPE,
81: balance_value4 NUMBER,
82: balance_name5 pay_balance_types.balance_name%TYPE,
83: balance_value5 NUMBER,
84: balance_name6 pay_balance_types.balance_name%TYPE,

Line 82: balance_name5 pay_balance_types.balance_name%TYPE,

78: balance_name3 pay_balance_types.balance_name%TYPE,
79: balance_value3 NUMBER,
80: balance_name4 pay_balance_types.balance_name%TYPE,
81: balance_value4 NUMBER,
82: balance_name5 pay_balance_types.balance_name%TYPE,
83: balance_value5 NUMBER,
84: balance_name6 pay_balance_types.balance_name%TYPE,
85: balance_value6 NUMBER,
86: input_date per_assignments_f.effective_end_date%TYPE,

Line 84: balance_name6 pay_balance_types.balance_name%TYPE,

80: balance_name4 pay_balance_types.balance_name%TYPE,
81: balance_value4 NUMBER,
82: balance_name5 pay_balance_types.balance_name%TYPE,
83: balance_value5 NUMBER,
84: balance_name6 pay_balance_types.balance_name%TYPE,
85: balance_value6 NUMBER,
86: input_date per_assignments_f.effective_end_date%TYPE,
87: input_start_date per_assignments_f.effective_end_date%TYPE,
88: assignment_id per_assignments_f.assignment_id%TYPE,

Line 100: FROM pay_balance_types pbt,

96: ins_val_t t_ins_val;
97:
98: CURSOR c1 IS
99: SELECT db.defined_balance_id, pbt.balance_name
100: FROM pay_balance_types pbt,
101: pay_defined_balances db,
102: pay_balance_dimensions bd
103: WHERE pbt.balance_name IN ('RA GRA PLAN BY INST',
104: 'RA GRA PLAN REDUCT',

Line 360: l_balance_name pay_balance_types.balance_name%TYPE := ' ';

356: l_balance_start NUMBER;
357: l_balance_end NUMBER;
358: l_defined_balance_id NUMBER;
359: l_def_balance_id pay_defined_balances.defined_balance_id%TYPE;
360: l_balance_name pay_balance_types.balance_name%TYPE := ' ';
361: l_tax_id NUMBER;
362: l_count_bal NUMBER :=0;
363: l_input_date per_assignments_f.effective_end_date%TYPE;
364: l_input_start_date per_assignments_f.effective_start_date%TYPE;