APPS.PAY_SE_ARCHIVE_CWCA dependencies on PAY_PAYROLL_ACTIONS

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

30: ,p_segment_number IN NUMBER DEFAULT NULL
31: )
32: 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 132: FROM pay_payroll_actions

128: )
129: ) report_month
130: ,effective_date effective_date
131: ,business_group_id bg_id
132: FROM pay_payroll_actions
133: WHERE payroll_action_id = p_payroll_action_id;
134:
135: lr_parameter_info csr_parameter_info%ROWTYPE;
136: l_proc VARCHAR2 (240)

Line 474: ,pay_payroll_actions ppa

470: );
471: p_sql :=
472: 'SELECT DISTINCT person_id
473: FROM per_people_f ppf
474: ,pay_payroll_actions ppa
475: WHERE ppa.payroll_action_id = :payroll_action_id
476: AND ppa.business_group_id = ppf.business_group_id
477: AND ppf.person_id = '''
478: || g_person_id

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

1237: NULL;
1238: END archive_code;
1239:
1240: PROCEDURE DEINITIALIZATION_CODE
1241: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
1242:
1243: BEGIN
1244: IF g_debug THEN
1245: hr_utility.set_location(' Entering Procedure DEINITIALIZATION_CODE',380);