DBA Data[Home] [Help]

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PAY_PAYROLL_ACTIONS

Line 622: pay_payroll_actions pact,

618:
619: cursor csr_latest_asg_act_id is
620: select max(paa.assignment_action_id)
621: from per_time_periods ptp,
622: pay_payroll_actions pact,
623: pay_assignment_actions paa
624: where paa.assignment_id = p_assignment_id
625: and paa.payroll_action_id = pact.payroll_action_id
626: and pact.time_period_id = ptp.time_period_id

Line 671: pay_payroll_actions pact,

667:
668: cursor csr_latest_asg_act_id is
669: select max(paa.assignment_action_id)
670: from per_time_periods ptp,
671: pay_payroll_actions pact,
672: pay_assignment_actions paa
673: where paa.assignment_id = p_assignment_id
674: and paa.payroll_action_id = pact.payroll_action_id
675: and pact.time_period_id = ptp.time_period_id