DBA Data[Home] [Help]

APPS.PAY_SIMULATOR_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 692: ,pay_payroll_actions ppa

688: SELECT paa.assignment_action_id assact
689: ,ppa.payroll_action_id pact_id
690: ,ppa.action_type act_type
691: FROM pay_assignment_actions paa
692: ,pay_payroll_actions ppa
693: WHERE paa.assignment_id = p_ass_id
694: AND paa.source_action_id IS NULL
695: AND ppa.payroll_action_id = paa.payroll_action_id
696: AND ppa.action_type IN ('Q','R','V'

Line 758: pay_payroll_actions ppa,

754:
755: SELECT paa.assignment_id, ptp.start_date, ptp.end_date
756: INTO v_ass_id,v_period_start_date,v_period_end_date
757: FROM pay_assignment_actions paa,
758: pay_payroll_actions ppa,
759: per_time_periods ptp
760: WHERE paa.assignment_action_id = p_assact_id
761: AND ppa.payroll_action_id = paa.payroll_action_id
762: AND ptp.time_period_id = ppa.time_period_id

Line 844: pay_payroll_actions ppa,

840:
841: SELECT paa.assignment_id, ptp.end_date
842: INTO v_asg_id,v_effective_date
843: FROM pay_assignment_actions paa,
844: pay_payroll_actions ppa,
845: per_time_periods ptp
846: WHERE paa.assignment_action_id = p_assact_id
847: AND ppa.payroll_action_id = paa.payroll_action_id
848: AND ptp.time_period_id = ppa.time_period_id

Line 949: pay_payroll_actions ppa,

945:
946: SELECT paa.assignment_id, ptp.start_date, ptp.end_date
947: INTO v_ass_id,v_period_start_date,v_period_end_date
948: FROM pay_assignment_actions paa,
949: pay_payroll_actions ppa,
950: per_time_periods ptp
951: WHERE paa.assignment_action_id = p_assact_id
952: AND ppa.payroll_action_id = paa.payroll_action_id
953: AND ptp.time_period_id = ppa.time_period_id