APPS.PAY_NO_K27_REIM_UPLD dependencies on PAY_PAYROLL_ACTIONS

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

261: p_parameter_string IN VARCHAR2
262: ,p_token IN VARCHAR2
263: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
264: IS
265: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
266: l_start_pos NUMBER;
267: l_delimiter VARCHAR2(1):=' ';
268: l_proc VARCHAR2(40):= g_package||' get parameter ';
269: BEGIN

Line 328: FROM pay_payroll_actions

324: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'FILE_NAME')
325: ,effective_date
326: ,business_group_id
327: ,PAY_NO_K27_REIM_UPLD.GET_PARAMETER(legislative_parameters,'PERIOD_DATE')
328: FROM pay_payroll_actions
329: WHERE payroll_action_id = p_payroll_action_id;
330:
331: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
332: --

Line 495: pay_payroll_actions ppa,

491:
492: CURSOR cur_is_payroll_run(p_assignment_id NUMBER, p_bg_id NUMBER, p_payroll_id NUMBER, p_period_date DATE )
493: IS
494: select 'Y' from
495: pay_payroll_actions ppa,
496: pay_assignment_actions paa
497: where
498: ppa.payroll_action_id = paa.payroll_action_id
499: and paa.assignment_id = p_assignment_id

Line 1093: pay_payroll_actions

1089: Cursor cur_report_type IS
1090: select
1091: report_type
1092: from
1093: pay_payroll_actions
1094: where payroll_action_id = p_payroll_action_id;
1095:
1096: l_report_type VARCHAR2(100);
1097:

Line 1118: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id

1114: IF g_debug THEN
1115: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
1116: END IF;
1117:
1118: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id
1119: AND ppa.business_group_id = ppf.business_group_id and 1=2 ORDER BY ppf.person_id ';
1120:
1121: hr_utility.set_location('RANGE_CODE:Before Calling GET_ALL_PARAMETERS',2);
1122: g_payroll_action_id := p_payroll_action_id;

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

1230: RAISE;
1231: END ARCHIVE_CODE;
1232:
1233: PROCEDURE DEINITIALIZATION_CODE
1234: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
1235: BEGIN
1236: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE START 1');
1237: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE END 2');
1238: EXCEPTION