DBA Data[Home] [Help]

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PER_TIME_PERIODS

Line 584: from per_time_periods ptp,

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

Line 632: from per_time_periods ptp,

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