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 FND_DATE

Line 83: country, fnd_date.canonical_to_date (action_information21) date_of_birth,

79: action_information14 insurance_salary, action_information15 address_line1,
80: action_information16
81: address_line2, action_information17 address_line3, action_information18 postal_code,
82: action_information19
83: country, fnd_date.canonical_to_date (action_information21) date_of_birth,
84: action_information22
85: job_name, action_information23 permanent_address_line1,
86: action_information24 permanent_address_line2, action_information25 permanent_address_line3,
87: action_information26

Line 106: fnd_date.canonical_to_date (action_information6)

102: p_payroll_action_id number,
103: p_person_id varchar2
104: ) is
105: select action_information4 payroll_id, action_information5 pay_period,
106: fnd_date.canonical_to_date (action_information6)
107: pay_period_start_date,
108: fnd_date.canonical_to_date (action_information7) pay_period_end_date, action_information8 period_type,
109: fnd_number.canonical_to_number (action_information9)
110: salary_income,

Line 108: fnd_date.canonical_to_date (action_information7) pay_period_end_date, action_information8 period_type,

104: ) is
105: select action_information4 payroll_id, action_information5 pay_period,
106: fnd_date.canonical_to_date (action_information6)
107: pay_period_start_date,
108: fnd_date.canonical_to_date (action_information7) pay_period_end_date, action_information8 period_type,
109: fnd_number.canonical_to_number (action_information9)
110: salary_income,
111: fnd_number.canonical_to_number (action_information10) benefits_in_kind, action_information11 benefit_type,
112: fnd_number.canonical_to_number (action_information12)

Line 144: select fnd_date.canonical_to_date (action_information6) pay_period_start_date,

140: cursor csr_get_benefits (
141: p_payroll_action_id number,
142: p_person_id varchar2
143: ) is
144: select fnd_date.canonical_to_date (action_information6) pay_period_start_date,
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

Line 145: fnd_date.canonical_to_date (action_information7)

141: p_payroll_action_id number,
142: p_person_id varchar2
143: ) is
144: select fnd_date.canonical_to_date (action_information6) pay_period_start_date,
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

Line 165: select fnd_date.canonical_to_date (action_information6) car_pay_period_start_date,

161: cursor csr_get_car_benefit (
162: p_payroll_action_id number,
163: p_person_id varchar2
164: ) is
165: select fnd_date.canonical_to_date (action_information6) car_pay_period_start_date,
166: fnd_date.canonical_to_date (action_information7)
167: car_pay_period_end_date,
168: action_information19 input_value_name, action_information20 input_value,
169: action_information22

Line 166: fnd_date.canonical_to_date (action_information7)

162: p_payroll_action_id number,
163: p_person_id varchar2
164: ) is
165: select fnd_date.canonical_to_date (action_information6) car_pay_period_start_date,
166: fnd_date.canonical_to_date (action_information7)
167: car_pay_period_end_date,
168: action_information19 input_value_name, action_information20 input_value,
169: action_information22
170: input_value_uom