APPS.PAY_FI_ARCHIVE_DPSA dependencies on PAY_PAYROLL_ACTIONS

Line 25: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

21: p_parameter_string IN VARCHAR2
22: ,p_token IN VARCHAR2
23: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
24: IS
25: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
26: l_start_pos NUMBER;
27: l_delimiter VARCHAR2(1):=' ';
28: l_proc VARCHAR2(40):= g_package||' get parameter ';
29: BEGIN

Line 88: FROM pay_payroll_actions

84: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'DEDUCTIONS_SS') DEDUCTIONS_SS
85: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
86: ,effective_date
87: ,business_group_id
88: FROM pay_payroll_actions
89: WHERE payroll_action_id = p_payroll_action_id;
90:
91: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
92: --

Line 223: ,pay_payroll_actions ppa

219: END IF;
220:
221: p_sql := 'SELECT DISTINCT person_id
222: FROM per_people_f ppf
223: ,pay_payroll_actions ppa
224: WHERE ppa.payroll_action_id = :payroll_action_id
225: AND ppa.business_group_id = ppf.business_group_id
226: ORDER BY ppf.person_id';
227:

Line 476: FROM pay_payroll_actions ppa

472: SELECT as1.person_id person_id,
473: act.assignment_id assignment_id,
474: act.assignment_action_id run_action_id,
475: act1.assignment_action_id prepaid_action_id
476: FROM pay_payroll_actions ppa
477: ,pay_payroll_actions appa
478: ,pay_payroll_actions appa2
479: ,pay_assignment_actions act
480: ,pay_assignment_actions act1

Line 477: ,pay_payroll_actions appa

473: act.assignment_id assignment_id,
474: act.assignment_action_id run_action_id,
475: act1.assignment_action_id prepaid_action_id
476: FROM pay_payroll_actions ppa
477: ,pay_payroll_actions appa
478: ,pay_payroll_actions appa2
479: ,pay_assignment_actions act
480: ,pay_assignment_actions act1
481: ,pay_action_interlocks pai

Line 478: ,pay_payroll_actions appa2

474: act.assignment_action_id run_action_id,
475: act1.assignment_action_id prepaid_action_id
476: FROM pay_payroll_actions ppa
477: ,pay_payroll_actions appa
478: ,pay_payroll_actions appa2
479: ,pay_assignment_actions act
480: ,pay_assignment_actions act1
481: ,pay_action_interlocks pai
482: ,per_all_assignments_f as1

Line 536: FROM pay_payroll_actions ppa

532: SELECT as1.person_id person_id,
533: act.assignment_id assignment_id,
534: act.assignment_action_id run_action_id,
535: act1.assignment_action_id prepaid_action_id
536: FROM pay_payroll_actions ppa
537: ,pay_payroll_actions appa
538: ,pay_payroll_actions appa2
539: ,pay_assignment_actions act
540: ,pay_assignment_actions act1

Line 537: ,pay_payroll_actions appa

533: act.assignment_id assignment_id,
534: act.assignment_action_id run_action_id,
535: act1.assignment_action_id prepaid_action_id
536: FROM pay_payroll_actions ppa
537: ,pay_payroll_actions appa
538: ,pay_payroll_actions appa2
539: ,pay_assignment_actions act
540: ,pay_assignment_actions act1
541: ,pay_action_interlocks pai

Line 538: ,pay_payroll_actions appa2

534: act.assignment_action_id run_action_id,
535: act1.assignment_action_id prepaid_action_id
536: FROM pay_payroll_actions ppa
537: ,pay_payroll_actions appa
538: ,pay_payroll_actions appa2
539: ,pay_assignment_actions act
540: ,pay_assignment_actions act1
541: ,pay_action_interlocks pai
542: ,per_all_assignments_f as1

Line 3088: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

3084: RAISE;
3085: END ARCHIVE_CODE;
3086:
3087: PROCEDURE DEINITIALIZATION_CODE
3088: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
3089:
3090: /* Cursor to retrieve data from the Header record(Employer level) */
3091: CURSOR csr_prpt_header (p_payroll_action_id NUMBER) IS
3092: SELECT action_information2 emp_type ,action_information3 emp_id