APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 269: FROM pay_assignment_actions paa,

265: c_effective_end_date IN DATE) is
266: SELECT /*+ USE_NL(paa, ppa) */
267: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
268: paa.assignment_action_id),16))
269: FROM pay_assignment_actions paa,
270: pay_payroll_actions ppa
271: WHERE
272: paa.assignment_id = c_assignment_id
273: AND ppa.payroll_action_id = paa.payroll_action_id

Line 286: FROM pay_assignment_actions paa,

282: c_master_asg_action_id IN NUMBER) is
283: SELECT /*+ USE_NL(paa, ppa) */
284: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
285: paa.assignment_action_id),16))
286: FROM pay_assignment_actions paa,
287: pay_payroll_actions ppa
288: WHERE
289: paa.assignment_id = c_assignment_id
290: AND ppa.payroll_action_id = paa.payroll_action_id

Line 822: FROM pay_assignment_actions paa

818: CURSOR csr_get_ass_act -- changed this name csr_get_end_date
819: IS
820: SELECT /*+ leading(paa) */
821: DISTINCT ptp.start_date start_date, ptp.end_date end_date
822: FROM pay_assignment_actions paa
823: ,pay_payroll_actions ppa
824: ,per_time_periods ptp
825: WHERE ptp.time_period_id = ppa.time_period_id
826: AND ppa.payroll_action_id = paa.payroll_action_id