APPS.PAY_FI_ARCHIVE_LTFA dependencies on PAY_PAYROLL_ACTIONS

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

30: p_parameter_string IN VARCHAR2
31: ,p_token IN VARCHAR2
32: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
33: IS
34: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
35: l_start_pos NUMBER;
36: l_delimiter VARCHAR2(1):=' ';
37: l_proc VARCHAR2(240):= g_package||' get parameter ';
38: BEGIN

Line 98: FROM pay_payroll_actions

94: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
95: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
96: ,effective_date
97: ,business_group_id
98: FROM pay_payroll_actions
99: WHERE payroll_action_id = p_payroll_action_id;
100: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
101: --
102: BEGIN

Line 311: ,pay_payroll_actions ppa

307: END IF;
308:
309: p_sql := 'SELECT DISTINCT person_id
310: FROM per_people_f ppf
311: ,pay_payroll_actions ppa
312: WHERE ppa.payroll_action_id = :payroll_action_id
313: AND ppa.business_group_id = ppf.business_group_id
314: ORDER BY ppf.person_id';
315: g_archive := NULL;

Line 601: FROM pay_payroll_actions ppa

597: IS
598: SELECT act.assignment_id assignment_id,
599: act.assignment_action_id run_action_id,
600: act1.assignment_action_id prepaid_action_id
601: FROM pay_payroll_actions ppa
602: ,pay_payroll_actions appa
603: ,pay_payroll_actions appa2
604: ,pay_assignment_actions act
605: ,pay_assignment_actions act1

Line 602: ,pay_payroll_actions appa

598: SELECT act.assignment_id assignment_id,
599: act.assignment_action_id run_action_id,
600: act1.assignment_action_id prepaid_action_id
601: FROM pay_payroll_actions ppa
602: ,pay_payroll_actions appa
603: ,pay_payroll_actions appa2
604: ,pay_assignment_actions act
605: ,pay_assignment_actions act1
606: ,pay_action_interlocks pai

Line 603: ,pay_payroll_actions appa2

599: act.assignment_action_id run_action_id,
600: act1.assignment_action_id prepaid_action_id
601: FROM pay_payroll_actions ppa
602: ,pay_payroll_actions appa
603: ,pay_payroll_actions appa2
604: ,pay_assignment_actions act
605: ,pay_assignment_actions act1
606: ,pay_action_interlocks pai
607: ,per_all_assignments_f as1

Line 652: FROM pay_payroll_actions ppa,

648: IS
649: SELECT act.assignment_id assignment_id,
650: act.assignment_action_id run_action_id,
651: act1.assignment_action_id prepaid_action_id
652: FROM pay_payroll_actions ppa,
653: pay_payroll_actions appa,
654: pay_payroll_actions appa2,
655: pay_assignment_actions act,
656: pay_assignment_actions act1,

Line 653: pay_payroll_actions appa,

649: SELECT act.assignment_id assignment_id,
650: act.assignment_action_id run_action_id,
651: act1.assignment_action_id prepaid_action_id
652: FROM pay_payroll_actions ppa,
653: pay_payroll_actions appa,
654: pay_payroll_actions appa2,
655: pay_assignment_actions act,
656: pay_assignment_actions act1,
657: pay_action_interlocks pai,

Line 654: pay_payroll_actions appa2,

650: act.assignment_action_id run_action_id,
651: act1.assignment_action_id prepaid_action_id
652: FROM pay_payroll_actions ppa,
653: pay_payroll_actions appa,
654: pay_payroll_actions appa2,
655: pay_assignment_actions act,
656: pay_assignment_actions act1,
657: pay_action_interlocks pai,
658: per_all_assignments_f as1

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

1080: END ARCHIVE_CODE;
1081:
1082:
1083: PROCEDURE DEINITIALIZATION_CODE
1084: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
1085:
1086: /*
1087: CURSOR csr_person_pay_action_info(p_payroll_action_id pay_action_information.action_information1%TYPE)
1088: IS