APPS.PAY_FI_PSTR dependencies on FND_NUMBER

Line 109: fnd_number.canonical_to_number (action_information9)

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)
113: benefit_monetary_value,

Line 111: fnd_number.canonical_to_number (action_information10) benefits_in_kind, action_information11 benefit_type,

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)
113: benefit_monetary_value,
114: fnd_number.canonical_to_number (action_information13) sal_sub_tax,
115: fnd_number.canonical_to_number (action_information14)

Line 112: fnd_number.canonical_to_number (action_information12)

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)
113: benefit_monetary_value,
114: fnd_number.canonical_to_number (action_information13) sal_sub_tax,
115: fnd_number.canonical_to_number (action_information14)
116: tax_amount,

Line 114: fnd_number.canonical_to_number (action_information13) sal_sub_tax,

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)
113: benefit_monetary_value,
114: fnd_number.canonical_to_number (action_information13) sal_sub_tax,
115: fnd_number.canonical_to_number (action_information14)
116: tax_amount,
117: fnd_number.canonical_to_number (action_information15) net_salary,
118: fnd_number.canonical_to_number (action_information16)

Line 115: fnd_number.canonical_to_number (action_information14)

111: fnd_number.canonical_to_number (action_information10) benefits_in_kind, action_information11 benefit_type,
112: fnd_number.canonical_to_number (action_information12)
113: benefit_monetary_value,
114: fnd_number.canonical_to_number (action_information13) sal_sub_tax,
115: fnd_number.canonical_to_number (action_information14)
116: tax_amount,
117: fnd_number.canonical_to_number (action_information15) net_salary,
118: fnd_number.canonical_to_number (action_information16)
119: deductions_b_tax,

Line 117: fnd_number.canonical_to_number (action_information15) net_salary,

113: benefit_monetary_value,
114: fnd_number.canonical_to_number (action_information13) sal_sub_tax,
115: fnd_number.canonical_to_number (action_information14)
116: tax_amount,
117: fnd_number.canonical_to_number (action_information15) net_salary,
118: fnd_number.canonical_to_number (action_information16)
119: deductions_b_tax,
120: fnd_number.canonical_to_number (action_information17) external_compensation,
121: fnd_number.canonical_to_number (action_information18)

Line 118: fnd_number.canonical_to_number (action_information16)

114: fnd_number.canonical_to_number (action_information13) sal_sub_tax,
115: fnd_number.canonical_to_number (action_information14)
116: tax_amount,
117: fnd_number.canonical_to_number (action_information15) net_salary,
118: fnd_number.canonical_to_number (action_information16)
119: deductions_b_tax,
120: fnd_number.canonical_to_number (action_information17) external_compensation,
121: fnd_number.canonical_to_number (action_information18)
122: time_period_id,

Line 120: fnd_number.canonical_to_number (action_information17) external_compensation,

116: tax_amount,
117: fnd_number.canonical_to_number (action_information15) net_salary,
118: fnd_number.canonical_to_number (action_information16)
119: deductions_b_tax,
120: fnd_number.canonical_to_number (action_information17) external_compensation,
121: fnd_number.canonical_to_number (action_information18)
122: time_period_id,
123: fnd_number.canonical_to_number (action_information19) pension,
124: fnd_number.canonical_to_number (action_information20)

Line 121: fnd_number.canonical_to_number (action_information18)

117: fnd_number.canonical_to_number (action_information15) net_salary,
118: fnd_number.canonical_to_number (action_information16)
119: deductions_b_tax,
120: fnd_number.canonical_to_number (action_information17) external_compensation,
121: fnd_number.canonical_to_number (action_information18)
122: time_period_id,
123: fnd_number.canonical_to_number (action_information19) pension,
124: fnd_number.canonical_to_number (action_information20)
125: unemployment_insurance,

Line 123: fnd_number.canonical_to_number (action_information19) pension,

119: deductions_b_tax,
120: fnd_number.canonical_to_number (action_information17) external_compensation,
121: fnd_number.canonical_to_number (action_information18)
122: time_period_id,
123: fnd_number.canonical_to_number (action_information19) pension,
124: fnd_number.canonical_to_number (action_information20)
125: unemployment_insurance,
126: fnd_number.canonical_to_number (action_information21) trade_union_fee,
127: fnd_number.canonical_to_number (action_information22)

Line 124: fnd_number.canonical_to_number (action_information20)

120: fnd_number.canonical_to_number (action_information17) external_compensation,
121: fnd_number.canonical_to_number (action_information18)
122: time_period_id,
123: fnd_number.canonical_to_number (action_information19) pension,
124: fnd_number.canonical_to_number (action_information20)
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

Line 126: fnd_number.canonical_to_number (action_information21) trade_union_fee,

122: time_period_id,
123: fnd_number.canonical_to_number (action_information19) pension,
124: fnd_number.canonical_to_number (action_information20)
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

Line 127: fnd_number.canonical_to_number (action_information22)

123: fnd_number.canonical_to_number (action_information19) pension,
124: fnd_number.canonical_to_number (action_information20)
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

Line 147: fnd_number.canonical_to_number (action_information12)

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
150: where paa.payroll_action_id = p_payroll_action_id
151: and assg.payroll_action_id = paa.payroll_action_id