DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on PAY_PAYROLL_ACTIONS

Line 37: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

33: -- PROCEDURE to return the sql statement to select the range of employees
34: -- to be processed.
35: --------------------------------------------------------------------------+
36: PROCEDURE range_code
37: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
38: p_sql out nocopy varchar2);
39:
40:
41:

Line 48: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

44: -- PROCEDURE to further restrict the assignments to be processed by the
45: -- archive process.
46: --------------------------------------------------------------------------+
47: PROCEDURE assignment_action_code
48: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
49: p_start_person_id in per_all_people_f.person_id%TYPE,
50: p_end_person_id in per_all_people_f.person_id%TYPE,
51: p_chunk in number);
52:

Line 60: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE);

56: --------------------------------------------------------------------------+
57: -- PROCEDURE to initialize the globals, plsql tables and contexts.
58: --------------------------------------------------------------------------+
59: PROCEDURE initialization_code
60: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE);
61:
62:
63:
64:

Line 293: ,pay_payroll_actions ppa

289: hr_soft_coding_keyflex hsc
290: ,per_assignments_f paa
291: ,per_people_f pap
292: ,per_addresses pad
293: ,pay_payroll_actions ppa
294: ,pay_assignment_actions pac
295: WHERE paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
296: AND ppa.report_type='AU_TFN_MAGTAPE' /*Bug4247686 */
297: AND ppa.report_qualifier='AU'