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 477: ,pay_payroll_actions ppa

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

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

1300: NULL;
1301: END archive_code;
1302:
1303: PROCEDURE DEINITIALIZATION_CODE
1304: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
1305:
1306: BEGIN
1307: IF g_debug THEN
1308: hr_utility.set_location(' Entering Procedure DEINITIALIZATION_CODE',380);