DBA Data[Home] [Help]

APPS.PQP_GB_PSI_HRS_HISTORY dependencies on FND_NUMBER

Line 1448: -- fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);

1444: -- -- This is a new hire event (includes rehires)
1445: -- -- Evaluate new joiners
1446: -- -- We are only interested in primary assignments
1447: -- l_assignment_id :=
1448: -- fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);
1449: --
1450: -- IF g_debug
1451: -- THEN
1452: -- l_proc_step := 80;

Line 1472: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).new_value);

1468: DEBUG(l_proc_name, l_proc_step);
1469: END IF;
1470:
1471: l_curr_status_type_id :=
1472: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).new_value);
1473: l_prev_status_type_id :=
1474: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).old_value);
1475: IF l_curr_status_type_id = g_terminate_asg_sts_id
1476: THEN

Line 1474: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).old_value);

1470:
1471: l_curr_status_type_id :=
1472: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).new_value);
1473: l_prev_status_type_id :=
1474: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).old_value);
1475: IF l_curr_status_type_id = g_terminate_asg_sts_id
1476: THEN
1477: IF g_debug
1478: THEN

Line 1517: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);

1513: l_proc_step := 130;
1514: DEBUG(l_proc_name, l_proc_step);
1515: END IF;
1516: l_surrogate_key :=
1517: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);
1518:
1519: l_include_flag := eval_fte_event
1520: (p_assignment_id => p_assignment_id
1521: ,p_table_name => l_table_name