APPS.PAY_IE_P45_ARCHIVE dependencies on FND_NUMBER

Line 1541: select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0) weeks

1537: -- starts with IE_A
1538: -- First part of the select retrives summed up values for Payroll runs,
1539: -- Second part of the select retrives summed up values for Uploaded Balance
1540: /* CURSOR csr_iea_weeks (p_balance_type_id in number) IS
1541: select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0) weeks
1542: from pay_run_result_values TARGET
1543: , pay_balance_feeds_f FEED
1544: , pay_run_results RR
1545: , pay_assignment_actions ASSACT

Line 1587: select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0) weeks

1583: and ACX_PROCESS_ID.context_value like 'IE_A%'
1584: and PPTP.regular_payment_date >= trunc(BPTP.regular_payment_date,'Y')
1585: and RR.entry_type <>'B' -- Bug 3079945 start
1586: union all
1587: select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0) weeks
1588: from pay_run_result_values TARGET
1589: , pay_run_results RR
1590: , pay_assignment_actions ASSACT
1591: , pay_balance_feeds_f FEED

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

3972: CURSOR cur_child_pay_action (p_person_id IN NUMBER,
3973: p_effective_date IN DATE,
3974: p_lat_act_seq IN NUMBER) is
3975: SELECT /*+ USE_NL(paa, ppa) */
3976: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3977: paa.assignment_action_id),16))
3978: FROM pay_assignment_actions paa,
3979: pay_payroll_actions ppa
3980: WHERE paa.payroll_action_id = ppa.payroll_action_id

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

4014:
4015: -- Cursor to fetch action context id of P45 for previous period of service.
4016: /* 7291676 */
4017: CURSOR cur_get_last_p45(p_person_id NUMBER,p_termination_date DATE,p_pact NUMBER, c_assignment_id NUMBER) IS
4018: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
4019: paa.assignment_action_id),16))
4020: FROM pay_payroll_actions ppa,
4021: pay_assignment_actions paa,
4022: pay_action_information pai

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

4066: p_effective_date IN DATE,
4067: p_lat_act_seq IN NUMBER,
4068: c_ppsn_override per_assignment_extra_info.aei_information1%type) is
4069: SELECT /*+ USE_NL(paa, ppa) */
4070: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
4071: paa.assignment_action_id),16))
4072: FROM pay_assignment_actions paa,
4073: pay_payroll_actions ppa
4074: WHERE paa.payroll_action_id = ppa.payroll_action_id