APPS.PAY_HK_IR56_MAGTAPE dependencies on PAY_PAYROLL_ACTIONS

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

37: /********************************************************
38: * Procedure to fetch RANGE CODE *
39: **********************************************************/
40: PROCEDURE range_code
41: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
42: p_sql out nocopy varchar2);
43:
44: /********************************************************
45: * Procedure to fetch ASSIGNMENT ACTION CODE *

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

45: * Procedure to fetch ASSIGNMENT ACTION CODE *
46: **********************************************************/
47:
48: PROCEDURE assignment_action_code
49: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
50: p_start_person_id in per_all_people_f.person_id%TYPE,
51: p_end_person_id in per_all_people_f.person_id%TYPE,
52: p_chunk in number) ;
53:

Line 73: pay_payroll_actions ppa,

69: sum(trunc(nvl(fai.value, 0))) amount /* Bug: 2913879 */
70: from ff_archive_items fai,
71: ff_user_entities fue,
72: pay_assignment_actions paa,
73: pay_payroll_actions ppa,
74: pay_payroll_actions ppa2,
75: pay_payroll_actions ppa3
76: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
77: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)

Line 74: pay_payroll_actions ppa2,

70: from ff_archive_items fai,
71: ff_user_entities fue,
72: pay_assignment_actions paa,
73: pay_payroll_actions ppa,
74: pay_payroll_actions ppa2,
75: pay_payroll_actions ppa3
76: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
77: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
78: and fue.user_entity_id = fai.user_entity_id

Line 75: pay_payroll_actions ppa3

71: ff_user_entities fue,
72: pay_assignment_actions paa,
73: pay_payroll_actions ppa,
74: pay_payroll_actions ppa2,
75: pay_payroll_actions ppa3
76: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
77: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
78: and fue.user_entity_id = fai.user_entity_id
79: and fue.user_entity_name like 'X_HK_IR56_%_ASG_LE_YTD'

Line 89: from pay_payroll_actions ppa,

85: group by paa.assignment_id
86: ) archive_count,
87: (
88: select paa.assignment_action_id
89: from pay_payroll_actions ppa,
90: pay_payroll_actions ppa2,
91: pay_assignment_actions paa,
92: pay_payroll_actions ppa3--archive action
93: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 90: pay_payroll_actions ppa2,

86: ) archive_count,
87: (
88: select paa.assignment_action_id
89: from pay_payroll_actions ppa,
90: pay_payroll_actions ppa2,
91: pay_assignment_actions paa,
92: pay_payroll_actions ppa3--archive action
93: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
94: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)

Line 92: pay_payroll_actions ppa3--archive action

88: select paa.assignment_action_id
89: from pay_payroll_actions ppa,
90: pay_payroll_actions ppa2,
91: pay_assignment_actions paa,
92: pay_payroll_actions ppa3--archive action
93: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
94: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
95: and ppa3.payroll_action_id = paa.payroll_action_id
96: and paa.action_status = 'C'

Line 123: pay_payroll_actions ppa, -- Magtape payroll action

119: pac3.assignment_action_id,
120: pap.last_name lname, /*Changed to get proper sorted order for bug 2690005*/
121: pap.first_name||' '||pap.middle_names fname
122: from per_assignments_f paa,
123: pay_payroll_actions ppa, -- Magtape payroll action
124: pay_payroll_actions ppa2, -- Report payroll action
125: pay_payroll_actions ppa3, -- Archive payroll action
126: pay_assignment_actions pac,
127: pay_assignment_actions pac3,

Line 124: pay_payroll_actions ppa2, -- Report payroll action

120: pap.last_name lname, /*Changed to get proper sorted order for bug 2690005*/
121: pap.first_name||' '||pap.middle_names fname
122: from per_assignments_f paa,
123: pay_payroll_actions ppa, -- Magtape payroll action
124: pay_payroll_actions ppa2, -- Report payroll action
125: pay_payroll_actions ppa3, -- Archive payroll action
126: pay_assignment_actions pac,
127: pay_assignment_actions pac3,
128: per_people_f pap

Line 125: pay_payroll_actions ppa3, -- Archive payroll action

121: pap.first_name||' '||pap.middle_names fname
122: from per_assignments_f paa,
123: pay_payroll_actions ppa, -- Magtape payroll action
124: pay_payroll_actions ppa2, -- Report payroll action
125: pay_payroll_actions ppa3, -- Archive payroll action
126: pay_assignment_actions pac,
127: pay_assignment_actions pac3,
128: per_people_f pap
129: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')