eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_PSTR dependencies on PAY_PAYROLL_ACTIONS

Line 55: from pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

51: p_legal_employer varchar2,
52: p_local_unit_id varchar2
53: ) is
54: select count (*)
55: from pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
56: where paa.payroll_action_id = p_payroll_action_id
57: and assg.payroll_action_id = paa.payroll_action_id
58: and pai.action_context_id = assg.assignment_action_id
59: and pai.action_context_type = 'AAP'

Line 89: from pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

85: job_name, action_information23 permanent_address_line1,
86: action_information24 permanent_address_line2, action_information25 permanent_address_line3,
87: action_information26
88: permanent_postal_code, action_information27 permanent_country
89: from pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
90: where paa.payroll_action_id = p_payroll_action_id
91: and assg.payroll_action_id = paa.payroll_action_id
92: and pai.action_context_id = assg.assignment_action_id
93: and pai.action_context_type = 'AAP'

Line 129: from pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

125: unemployment_insurance,
126: fnd_number.canonical_to_number (action_information21) trade_union_fee,
127: fnd_number.canonical_to_number (action_information22)
128: car_benefit
129: from pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
130: where paa.payroll_action_id = p_payroll_action_id
131: and assg.payroll_action_id = paa.payroll_action_id
132: and pai.action_context_id = assg.assignment_action_id
133: and pai.action_context_type = 'AAP'

Line 149: from pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

145: fnd_date.canonical_to_date (action_information7)
146: pay_period_end_date, action_information11 benefit_type,
147: fnd_number.canonical_to_number (action_information12)
148: benefit_value
149: from pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
150: where paa.payroll_action_id = p_payroll_action_id
151: and assg.payroll_action_id = paa.payroll_action_id
152: and pai.action_context_id = assg.assignment_action_id
153: and pai.action_context_type = 'AAP'

Line 171: from pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

167: car_pay_period_end_date,
168: action_information19 input_value_name, action_information20 input_value,
169: action_information22
170: input_value_uom
171: from pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
172: where paa.payroll_action_id = p_payroll_action_id
173: and assg.payroll_action_id = paa.payroll_action_id
174: and pai.action_context_id = assg.assignment_action_id
175: and pai.action_context_type = 'AAP'

Line 208: from pay_payroll_actions ppa, fnd_conc_req_summary_v fcrs, fnd_conc_req_summary_v fcrs1

204: if p_payroll_action_id is null then
205: begin
206: select payroll_action_id
207: into l_payroll_action_id
208: from pay_payroll_actions ppa, fnd_conc_req_summary_v fcrs, fnd_conc_req_summary_v fcrs1
209: where fcrs.request_id = fnd_global.conc_request_id
210: and fcrs.priority_request_id = fcrs1.priority_request_id
211: and ppa.request_id between fcrs1.request_id and fcrs.request_id
212: and ppa.request_id = fcrs1.request_id;