APPS.PQP_EXCP_RPT dependencies on FND_NUMBER

Line 21: fnd_number.canonical_to_number(purt.business_group_id) business_group_id,

17: -- Cursor to get the row from the pay_us_rpt_totals table
18: --
19: CURSOR c_exception_report_data IS
20: SELECT
21: fnd_number.canonical_to_number(purt.business_group_id) business_group_id,
22: fnd_number.canonical_to_number(purt.tax_unit_id) payroll_action_id,
23: fnd_number.canonical_to_number(purt.value1) current_balance,
24: fnd_number.canonical_to_number(purt.value2) previous_balance,
25: fnd_number.canonical_to_number(purt.attribute1) balance_type_id,

Line 22: fnd_number.canonical_to_number(purt.tax_unit_id) payroll_action_id,

18: --
19: CURSOR c_exception_report_data IS
20: SELECT
21: fnd_number.canonical_to_number(purt.business_group_id) business_group_id,
22: fnd_number.canonical_to_number(purt.tax_unit_id) payroll_action_id,
23: fnd_number.canonical_to_number(purt.value1) current_balance,
24: fnd_number.canonical_to_number(purt.value2) previous_balance,
25: fnd_number.canonical_to_number(purt.attribute1) balance_type_id,
26: fnd_number.canonical_to_number(purt.attribute2) report_id,

Line 23: fnd_number.canonical_to_number(purt.value1) current_balance,

19: CURSOR c_exception_report_data IS
20: SELECT
21: fnd_number.canonical_to_number(purt.business_group_id) business_group_id,
22: fnd_number.canonical_to_number(purt.tax_unit_id) payroll_action_id,
23: fnd_number.canonical_to_number(purt.value1) current_balance,
24: fnd_number.canonical_to_number(purt.value2) previous_balance,
25: fnd_number.canonical_to_number(purt.attribute1) balance_type_id,
26: fnd_number.canonical_to_number(purt.attribute2) report_id,
27: fnd_number.canonical_to_number(purt.attribute3) group_id,

Line 24: fnd_number.canonical_to_number(purt.value2) previous_balance,

20: SELECT
21: fnd_number.canonical_to_number(purt.business_group_id) business_group_id,
22: fnd_number.canonical_to_number(purt.tax_unit_id) payroll_action_id,
23: fnd_number.canonical_to_number(purt.value1) current_balance,
24: fnd_number.canonical_to_number(purt.value2) previous_balance,
25: fnd_number.canonical_to_number(purt.attribute1) balance_type_id,
26: fnd_number.canonical_to_number(purt.attribute2) report_id,
27: fnd_number.canonical_to_number(purt.attribute3) group_id,
28: fnd_number.canonical_to_number(purt.attribute4) consolidation_set_id,

Line 25: fnd_number.canonical_to_number(purt.attribute1) balance_type_id,

21: fnd_number.canonical_to_number(purt.business_group_id) business_group_id,
22: fnd_number.canonical_to_number(purt.tax_unit_id) payroll_action_id,
23: fnd_number.canonical_to_number(purt.value1) current_balance,
24: fnd_number.canonical_to_number(purt.value2) previous_balance,
25: fnd_number.canonical_to_number(purt.attribute1) balance_type_id,
26: fnd_number.canonical_to_number(purt.attribute2) report_id,
27: fnd_number.canonical_to_number(purt.attribute3) group_id,
28: fnd_number.canonical_to_number(purt.attribute4) consolidation_set_id,
29: fnd_number.canonical_to_number(purt.attribute5) payroll_id,

Line 26: fnd_number.canonical_to_number(purt.attribute2) report_id,

22: fnd_number.canonical_to_number(purt.tax_unit_id) payroll_action_id,
23: fnd_number.canonical_to_number(purt.value1) current_balance,
24: fnd_number.canonical_to_number(purt.value2) previous_balance,
25: fnd_number.canonical_to_number(purt.attribute1) balance_type_id,
26: fnd_number.canonical_to_number(purt.attribute2) report_id,
27: fnd_number.canonical_to_number(purt.attribute3) group_id,
28: fnd_number.canonical_to_number(purt.attribute4) consolidation_set_id,
29: fnd_number.canonical_to_number(purt.attribute5) payroll_id,
30: fnd_number.canonical_to_number(purt.attribute6) assignment_id,

Line 27: fnd_number.canonical_to_number(purt.attribute3) group_id,

23: fnd_number.canonical_to_number(purt.value1) current_balance,
24: fnd_number.canonical_to_number(purt.value2) previous_balance,
25: fnd_number.canonical_to_number(purt.attribute1) balance_type_id,
26: fnd_number.canonical_to_number(purt.attribute2) report_id,
27: fnd_number.canonical_to_number(purt.attribute3) group_id,
28: fnd_number.canonical_to_number(purt.attribute4) consolidation_set_id,
29: fnd_number.canonical_to_number(purt.attribute5) payroll_id,
30: fnd_number.canonical_to_number(purt.attribute6) assignment_id,
31: purt.attribute14 full_name,

Line 28: fnd_number.canonical_to_number(purt.attribute4) consolidation_set_id,

24: fnd_number.canonical_to_number(purt.value2) previous_balance,
25: fnd_number.canonical_to_number(purt.attribute1) balance_type_id,
26: fnd_number.canonical_to_number(purt.attribute2) report_id,
27: fnd_number.canonical_to_number(purt.attribute3) group_id,
28: fnd_number.canonical_to_number(purt.attribute4) consolidation_set_id,
29: fnd_number.canonical_to_number(purt.attribute5) payroll_id,
30: fnd_number.canonical_to_number(purt.attribute6) assignment_id,
31: purt.attribute14 full_name,
32: purt.attribute7 last_name,

Line 29: fnd_number.canonical_to_number(purt.attribute5) payroll_id,

25: fnd_number.canonical_to_number(purt.attribute1) balance_type_id,
26: fnd_number.canonical_to_number(purt.attribute2) report_id,
27: fnd_number.canonical_to_number(purt.attribute3) group_id,
28: fnd_number.canonical_to_number(purt.attribute4) consolidation_set_id,
29: fnd_number.canonical_to_number(purt.attribute5) payroll_id,
30: fnd_number.canonical_to_number(purt.attribute6) assignment_id,
31: purt.attribute14 full_name,
32: purt.attribute7 last_name,
33: purt.attribute8 first_name,

Line 30: fnd_number.canonical_to_number(purt.attribute6) assignment_id,

26: fnd_number.canonical_to_number(purt.attribute2) report_id,
27: fnd_number.canonical_to_number(purt.attribute3) group_id,
28: fnd_number.canonical_to_number(purt.attribute4) consolidation_set_id,
29: fnd_number.canonical_to_number(purt.attribute5) payroll_id,
30: fnd_number.canonical_to_number(purt.attribute6) assignment_id,
31: purt.attribute14 full_name,
32: purt.attribute7 last_name,
33: purt.attribute8 first_name,
34: purt.attribute10 middle_name,