16:
17: CURSOR c_get_trx_date
18: IS
19: Select to_char(nvl(ppa.overriding_dd_date, nvl(ptp.default_dd_date, ptp.end_date)), 'YYYY/MM/DD')
20: from pay_assignment_actions paa,
21: pay_pre_payments ppp,
22: pay_assignment_actions paa2,
23: pay_payroll_actions ppa,
24: per_time_periods ptp
18: IS
19: Select to_char(nvl(ppa.overriding_dd_date, nvl(ptp.default_dd_date, ptp.end_date)), 'YYYY/MM/DD')
20: from pay_assignment_actions paa,
21: pay_pre_payments ppp,
22: pay_assignment_actions paa2,
23: pay_payroll_actions ppa,
24: per_time_periods ptp
25: where paa.assignment_action_id = p_assignment_action_id
26: and paa.PRE_PAYMENT_ID = ppp.PRE_PAYMENT_ID
53:
54:
55: cursor acb_effective_date IS
56: select ppa.effective_date
57: from pay_assignment_actions paa,
58: pay_pre_payments ppp,
59: pay_assignment_actions paa2,
60: pay_payroll_actions ppa
61: where paa.assignment_action_id = p_assignment_action_id
55: cursor acb_effective_date IS
56: select ppa.effective_date
57: from pay_assignment_actions paa,
58: pay_pre_payments ppp,
59: pay_assignment_actions paa2,
60: pay_payroll_actions ppa
61: where paa.assignment_action_id = p_assignment_action_id
62: and paa.PRE_PAYMENT_ID = ppp.PRE_PAYMENT_ID
63: and paa2.assignment_action_id = ( select max(locked_action_id)