eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_PSI_BASIC_DATA dependencies on BEN_EXT_PERSON

Line 492: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

488: );
489:
490:
491: -- set the global events table
492: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
493:
494: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
495:
496: debug('----------');

Line 494: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

490:
491: -- set the global events table
492: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
493:
494: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
495:
496: debug('----------');
497: debug('Record :'||l_curr_evt_index);
498: debug('----------');

Line 680: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'

676:
677: debug('location_code:' || p_return, 30);
678:
679: --
680: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'
681: and
682: ben_ext_person.g_chg_pay_column = 'LOCATION_ID'
683: THEN -- this is checking location_event for case (3) and (4)
684:

Line 682: ben_ext_person.g_chg_pay_column = 'LOCATION_ID'

678:
679: --
680: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'
681: and
682: ben_ext_person.g_chg_pay_column = 'LOCATION_ID'
683: THEN -- this is checking location_event for case (3) and (4)
684:
685: /*
686: ' debug('Location change event detected .. ', 40);

Line 688: IF ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value IS NULL

684:
685: /*
686: ' debug('Location change event detected .. ', 40);
687: -- check if previous value was null, if yes, then spaces
688: IF ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value IS NULL
689: THEN -- previous value was null, so spaces
690: debug('Old Value : '
691: || ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value, 50);
692: p_return := ' ';

Line 691: || ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value, 50);

687: -- check if previous value was null, if yes, then spaces
688: IF ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value IS NULL
689: THEN -- previous value was null, so spaces
690: debug('Old Value : '
691: || ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value, 50);
692: p_return := ' ';
693: ELSE -- previous value was not null, report asterisk, so return NULL
694: debug('Old Value : '
695: || ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value, 60);

Line 695: || ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value, 60);

691: || ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value, 50);
692: p_return := ' ';
693: ELSE -- previous value was not null, report asterisk, so return NULL
694: debug('Old Value : '
695: || ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value, 60);
696: p_return := NULL;
697: END IF;
698: --
699: */

Line 700: IF ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value IS NOT NULL

696: p_return := NULL;
697: END IF;
698: --
699: */
700: IF ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value IS NOT NULL
701: THEN
702: OPEN csr_location_code
703: (p_location_id
704: => ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value

Line 704: => ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value

700: IF ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value IS NOT NULL
701: THEN
702: OPEN csr_location_code
703: (p_location_id
704: => ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value
705: );
706: FETCH csr_location_code into l_location_code;
707: IF csr_location_code%FOUND THEN
708: debug('Old Value : '

Line 709: || ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value, 60);

705: );
706: FETCH csr_location_code into l_location_code;
707: IF csr_location_code%FOUND THEN
708: debug('Old Value : '
709: || ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value, 60);
710: p_return := NULL;
711:
712: ELSE
713:

Line 715: || ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value, 50);

711:
712: ELSE
713:
714: debug('Old Value : '
715: || ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value, 50);
716: p_return := ' ';
717: END IF;
718: CLOSE csr_location_code;
719: ELSE

Line 1528: ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'

1524: -- the logic below is to handle new_hires
1525: -- if new_hire, asterisk behaviour should be like "CUTOVER"
1526: IF g_current_run = 'PERIODIC'
1527: and
1528: ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'
1529: and
1530: ben_ext_person.g_chg_update_type = 'I'
1531: THEN
1532: p_output := 'CUTOVER';

Line 1530: ben_ext_person.g_chg_update_type = 'I'

1526: IF g_current_run = 'PERIODIC'
1527: and
1528: ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'
1529: and
1530: ben_ext_person.g_chg_update_type = 'I'
1531: THEN
1532: p_output := 'CUTOVER';
1533: ELSE
1534: p_output := g_current_run;