APPS.PAY_SIMULATOR_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 691: FROM pay_assignment_actions paa

687: CURSOR csr_rollback_actions IS
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

Line 757: FROM pay_assignment_actions paa,

753: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
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

Line 843: FROM pay_assignment_actions paa,

839: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
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

Line 918: from pay_assignment_actions

914: ,10;
915:
916: cursor ass_actions is
917: select assignment_action_id
918: from pay_assignment_actions
919: where source_action_id = p_assact_id;
920: BEGIN
921:
922: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

Line 948: FROM pay_assignment_actions paa,

944:
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

Line 1173: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;

1169:
1170: lv_action_parameter_value pay_action_parameters.parameter_value%TYPE;
1171: lv_retain_simulation_data VARCHAR2(10);
1172:
1173: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
1174: BEGIN
1175: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1176:
1177: lv_retain_simulation_data := 'NO';