APPS.PAY_IE_P35 dependencies on FND_NUMBER

Line 799: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa -- Bug 4672715

795: IS
796: SELECT /*+ ORDERED USE_NL(asg, paa, ppa, ptp, flex) push_subq */
797: asg.person_id,
798: paa.assignment_id,
799: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa -- Bug 4672715
800: FROM per_assignments_f asg,
801: pay_assignment_actions paa,
802: pay_payroll_actions ppa,
803: pay_all_payrolls_f pap,

Line 934: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) desc, -- Bug 4672715

930: AND ppf_p35.soft_coding_keyflex_id = flex_p35.soft_coding_keyflex_id
931: AND flex_p35.segment4 = l_segment4)
932: GROUP BY asg.person_id,paa.assignment_id
933: ORDER BY asg.person_id,
934: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) desc, -- Bug 4672715
935: paa.assignment_id desc;
936:
937: --6633719
938: cursor csr_ppsn_override(p_asg_id number)

Line 984: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id

980: AND pivf.name = 'Tax Basis'
981: and result_value = 'IE_EXCLUDE';
982:
983: CURSOR csr_action_type (p_assignment_id NUMBER) IS
984: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
985: FROM pay_assignment_actions paa,
986: pay_payroll_actions ppa
987: WHERE ppa.payroll_action_id = paa.payroll_action_id
988: and paa.assignment_id = p_assignment_id

Line 2137: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

2133: WHERE paa.run_type_id = prt.run_type_id
2134: AND prt.run_method IN ('N','P')
2135: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2136: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2137: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2138: paa.assignment_action_id),16)) child_assignment_action_id
2139: FROM pay_assignment_actions paa,
2140: pay_payroll_actions ppa
2141: WHERE paa.assignment_id = p_asg_id

Line 4672: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

4668: p_end_date DATE
4669: )
4670: IS
4671: SELECT /*+ ORDERED USE_NL(paa, ppa, ptp)
4672: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
4673: paa.assignment_action_id),16)) assignment_action_id --bug fix 4004470
4674: FROM per_people_f ppf,
4675: per_assignments_f paf,
4676: pay_assignment_actions paa,