APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 340: ,pay_payroll_actions PACT,

336: select distinct CONTEXT.result_value
337: from pay_run_result_values CONTEXT
338: ,pay_input_values_f PIVF
339: ,pay_run_results RR
340: ,pay_payroll_actions PACT,
341: pay_assignment_actions paa
342: where CONTEXT.run_result_id = RR.run_result_id
343: and CONTEXT.input_value_id = PIVF.input_value_id
344: and PIVF.name = 'Source'

Line 441: ,pay_payroll_Actions ppa

437: SELECT pac.assignment_action_id
438: ,pac.source_action_id
439: FROM pay_action_interlocks pai
440: ,pay_assignment_actions pac
441: ,pay_payroll_Actions ppa
442: WHERE pai.locking_action_id = p_pre_assignment_action_id
443: AND pai.locked_action_id = pac.assignment_action_id
444: AND ppa.payroll_action_id = pac.payroll_action_id
445: AND (ppa.run_type_id IS NULL

Line 743: PROCEDURE range_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)

739: also archives the payroll level data -
740: Messages and Employer address details.
741: *********************************************************************/
742:
743: PROCEDURE range_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)
744: IS
745:
746: -- Cursor to get the pay advice message
747:

Line 759: pay_payroll_actions ppa

755: ,ppa.effective_date run_effective_date
756: ,ppa.date_earned date_earned
757: ,ppa.pay_advice_message payroll_message
758: FROM pay_payrolls_f pp,
759: pay_payroll_actions ppa
760: WHERE ppa.payroll_id = p_payroll_id
761: AND ppa.effective_date BETWEEN p_start_date AND p_end_date
762: AND ppa.action_type = 'R'
763: AND ppa.action_status = 'C'

Line 777: pay_payroll_actions ppa,

773: ,ppa.effective_date run_effective_date
774: ,ppa.date_earned date_earned
775: ,ppa.pay_advice_message payroll_message
776: FROM pay_payrolls_f pp,
777: pay_payroll_actions ppa,
778: pay_assignment_actions paa
779: WHERE ppa.payroll_id = p_payroll_id
780: AND ppa.effective_date BETWEEN p_start_date AND p_end_date
781: AND ppa.action_type = 'Q'

Line 895: PROCEDURE initialization_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)

891: Purpose : Calls process_eit to set the globals.
892: *********************************************************************/
893:
894:
895: PROCEDURE initialization_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)
896: IS
897:
898: l_archive VARCHAR2(1);
899:

Line 944: PROCEDURE get_legislative_parameters(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

940: END_DATE ---- End Date
941:
942: *********************************************************************/
943:
944: PROCEDURE get_legislative_parameters(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
945: p_payroll_id OUT NOCOPY NUMBER,
946: p_consolidation OUT NOCOPY NUMBER,
947: p_business_group_id OUT NOCOPY NUMBER,
948: p_start_date OUT NOCOPY VARCHAR2,

Line 955: CURSOR csr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

951:
952:
953: -- Cursor to get legislative parameters from the archive request
954:
955: CURSOR csr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
956: IS
957: SELECT pay_core_utils.get_parameter('PAYROLL',legislative_parameters) payroll_id,
958: pay_core_utils.get_parameter('CONSOLIDATION',legislative_parameters) consolidation_set_id,
959: pay_core_utils.get_parameter('BG_ID',legislative_parameters) business_group_id,

Line 962: FROM pay_payroll_actions ppa

958: pay_core_utils.get_parameter('CONSOLIDATION',legislative_parameters) consolidation_set_id,
959: pay_core_utils.get_parameter('BG_ID',legislative_parameters) business_group_id,
960: pay_core_utils.get_parameter('START_DATE',legislative_parameters) start_date,
961: pay_core_utils.get_parameter('END_DATE',legislative_parameters) end_date
962: FROM pay_payroll_actions ppa
963: WHERE ppa.payroll_action_id = p_payroll_action_id;
964:
965: BEGIN
966: g_debug := hr_utility.debug_enabled;