APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 338: ,pay_payroll_actions PACT,

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

Line 439: ,pay_payroll_Actions ppa

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

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

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

Line 755: pay_payroll_actions ppa

751: ,ppa.effective_date run_effective_date
752: ,ppa.date_earned date_earned
753: ,ppa.pay_advice_message payroll_message
754: FROM pay_payrolls_f pp,
755: pay_payroll_actions ppa
756: WHERE ppa.payroll_id = p_payroll_id
757: AND ppa.effective_date BETWEEN p_start_date
758: AND p_end_date
759: AND (ppa.action_type = 'R' OR

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

868: Purpose : Calls process_eit to set the globals.
869: *********************************************************************/
870:
871:
872: PROCEDURE initialization_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)
873: IS
874:
875: l_archive VARCHAR2(1);
876:

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

917: END_DATE ---- End Date
918:
919: *********************************************************************/
920:
921: PROCEDURE get_legislative_parameters(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
922: p_payroll_id OUT NOCOPY NUMBER,
923: p_consolidation OUT NOCOPY NUMBER,
924: p_business_group_id OUT NOCOPY NUMBER,
925: p_start_date OUT NOCOPY VARCHAR2,

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

928:
929:
930: -- Cursor to get legislative parameters from the archive request
931:
932: CURSOR csr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
933: IS
934: SELECT pay_core_utils.get_parameter('PAYROLL',legislative_parameters) payroll_id,
935: pay_core_utils.get_parameter('CONSOLIDATION',legislative_parameters) consolidation_set_id,
936: pay_core_utils.get_parameter('BG_ID',legislative_parameters) business_group_id,

Line 939: FROM pay_payroll_actions ppa

935: pay_core_utils.get_parameter('CONSOLIDATION',legislative_parameters) consolidation_set_id,
936: pay_core_utils.get_parameter('BG_ID',legislative_parameters) business_group_id,
937: pay_core_utils.get_parameter('START_DATE',legislative_parameters) start_date,
938: pay_core_utils.get_parameter('END_DATE',legislative_parameters) end_date
939: FROM pay_payroll_actions ppa
940: WHERE ppa.payroll_action_id = p_payroll_action_id;
941:
942: BEGIN
943: g_debug := hr_utility.debug_enabled;