APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on FND_NUMBER

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

263: cursor get_master_latest_id (c_assignment_id IN NUMBER,
264: c_effective_start_date IN DATE,
265: c_effective_end_date IN DATE) is
266: SELECT /*+ USE_NL(paa, ppa) */
267: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
268: paa.assignment_action_id),16))
269: FROM pay_assignment_actions paa,
270: pay_payroll_actions ppa
271: WHERE

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

280: cursor get_latest_id (c_assignment_id IN NUMBER,
281: c_effective_date IN DATE,
282: c_master_asg_action_id IN NUMBER) is
283: SELECT /*+ USE_NL(paa, ppa) */
284: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
285: paa.assignment_action_id),16))
286: FROM pay_assignment_actions paa,
287: pay_payroll_actions ppa
288: WHERE

Line 2006: fnd_number.canonical_to_number(p_tab_pen_sch_map_cv(i).pcv_information1);

2002:
2003: WHILE i IS NOT NULL
2004: LOOP
2005: l_element_type_id :=
2006: fnd_number.canonical_to_number(p_tab_pen_sch_map_cv(i).pcv_information1);
2007:
2008: IF g_debug
2009: THEN
2010: l_proc_step := 20;

Line 2826: fnd_number.canonical_to_number(g_tab_pen_sch_map_cv(i).pcv_information1);

2822:
2823: WHILE i IS NOT NULL
2824: LOOP
2825: l_element_type_id :=
2826: fnd_number.canonical_to_number(g_tab_pen_sch_map_cv(i).pcv_information1);
2827: l_psi_pens_category :=
2828: g_tab_pen_sch_map_cv(i).pcv_information2;
2829: -- l_input_value_id := get_input_value_id(p_element_type_id => l_element_type_id
2830: -- ,p_effective_date => g_effective_date