DBA Data[Home] [Help]

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PER_TIME_PERIODS

Line 621: from per_time_periods ptp,

617: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
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

Line 670: from per_time_periods ptp,

666: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
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