DBA Data[Home] [Help]

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PAY_PAYROLL_ACTIONS

Line 585: pay_payroll_actions pact,

581:
582: cursor csr_latest_asg_act_id is
583: select max(paa.assignment_action_id)
584: from per_time_periods ptp,
585: pay_payroll_actions pact,
586: pay_assignment_actions paa
587: where paa.assignment_id = p_assignment_id
588: and paa.payroll_action_id = pact.payroll_action_id
589: and pact.time_period_id = ptp.time_period_id

Line 633: pay_payroll_actions pact,

629:
630: cursor csr_latest_asg_act_id is
631: select max(paa.assignment_action_id)
632: from per_time_periods ptp,
633: pay_payroll_actions pact,
634: pay_assignment_actions paa
635: where paa.assignment_id = p_assignment_id
636: and paa.payroll_action_id = pact.payroll_action_id
637: and pact.time_period_id = ptp.time_period_id