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_ADDDRESS dependencies on BEN_EXT_PERSON

Line 223: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

219: g_assignment_id := p_assignment_id;
220: debug('g_assignment_id: '||g_assignment_id,10);
221:
222: -- set the global events table
223: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
224:
225: -- set global person id
226: g_person_id := PQP_GB_PSI_FUNCTIONS.get_current_extract_person
227: (

Line 476: debug('ben_ext_person.g_chg_pay_table '||ben_ext_person.g_chg_pay_table,10);

472: debug('Inputs are: ',10);
473: debug('p_business_group_id: '||p_business_group_id,10);
474: debug('p_assignment_id: '||p_assignment_id,10);
475:
476: debug('ben_ext_person.g_chg_pay_table '||ben_ext_person.g_chg_pay_table,10);
477: debug('ben_ext_person.g_chg_pay_column '||ben_ext_person.g_chg_pay_column,10);
478: debug('ben_ext_person.g_chg_eff_dt '||ben_ext_person.g_chg_eff_dt,10);
479: debug('ben_ext_person.g_chg_update_type '||ben_ext_person.g_chg_update_type,10);
480: debug('ben_ext_person.g_chg_surrogate_key '||ben_ext_person.g_chg_surrogate_key,10);

Line 477: debug('ben_ext_person.g_chg_pay_column '||ben_ext_person.g_chg_pay_column,10);

473: debug('p_business_group_id: '||p_business_group_id,10);
474: debug('p_assignment_id: '||p_assignment_id,10);
475:
476: debug('ben_ext_person.g_chg_pay_table '||ben_ext_person.g_chg_pay_table,10);
477: debug('ben_ext_person.g_chg_pay_column '||ben_ext_person.g_chg_pay_column,10);
478: debug('ben_ext_person.g_chg_eff_dt '||ben_ext_person.g_chg_eff_dt,10);
479: debug('ben_ext_person.g_chg_update_type '||ben_ext_person.g_chg_update_type,10);
480: debug('ben_ext_person.g_chg_surrogate_key '||ben_ext_person.g_chg_surrogate_key,10);
481:

Line 478: debug('ben_ext_person.g_chg_eff_dt '||ben_ext_person.g_chg_eff_dt,10);

474: debug('p_assignment_id: '||p_assignment_id,10);
475:
476: debug('ben_ext_person.g_chg_pay_table '||ben_ext_person.g_chg_pay_table,10);
477: debug('ben_ext_person.g_chg_pay_column '||ben_ext_person.g_chg_pay_column,10);
478: debug('ben_ext_person.g_chg_eff_dt '||ben_ext_person.g_chg_eff_dt,10);
479: debug('ben_ext_person.g_chg_update_type '||ben_ext_person.g_chg_update_type,10);
480: debug('ben_ext_person.g_chg_surrogate_key '||ben_ext_person.g_chg_surrogate_key,10);
481:
482: -- reset salary globals

Line 479: debug('ben_ext_person.g_chg_update_type '||ben_ext_person.g_chg_update_type,10);

475:
476: debug('ben_ext_person.g_chg_pay_table '||ben_ext_person.g_chg_pay_table,10);
477: debug('ben_ext_person.g_chg_pay_column '||ben_ext_person.g_chg_pay_column,10);
478: debug('ben_ext_person.g_chg_eff_dt '||ben_ext_person.g_chg_eff_dt,10);
479: debug('ben_ext_person.g_chg_update_type '||ben_ext_person.g_chg_update_type,10);
480: debug('ben_ext_person.g_chg_surrogate_key '||ben_ext_person.g_chg_surrogate_key,10);
481:
482: -- reset salary globals
483: g_current_run := 'PERIODIC';

Line 480: debug('ben_ext_person.g_chg_surrogate_key '||ben_ext_person.g_chg_surrogate_key,10);

476: debug('ben_ext_person.g_chg_pay_table '||ben_ext_person.g_chg_pay_table,10);
477: debug('ben_ext_person.g_chg_pay_column '||ben_ext_person.g_chg_pay_column,10);
478: debug('ben_ext_person.g_chg_eff_dt '||ben_ext_person.g_chg_eff_dt,10);
479: debug('ben_ext_person.g_chg_update_type '||ben_ext_person.g_chg_update_type,10);
480: debug('ben_ext_person.g_chg_surrogate_key '||ben_ext_person.g_chg_surrogate_key,10);
481:
482: -- reset salary globals
483: g_current_run := 'PERIODIC';
484: g_effective_date := p_effective_date;

Line 549: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

545: ,p_effective_date => p_effective_date
546: );
547: END IF;
548: ----------- added in version 115.15
549: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
550: l_change_table := ben_ext_person.g_chg_pay_table;
551: l_change_column := ben_ext_person.g_chg_pay_column;
552: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
553:

Line 550: l_change_table := ben_ext_person.g_chg_pay_table;

546: );
547: END IF;
548: ----------- added in version 115.15
549: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
550: l_change_table := ben_ext_person.g_chg_pay_table;
551: l_change_column := ben_ext_person.g_chg_pay_column;
552: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
553:
554: debug('Calling the common include event proc');

Line 551: l_change_column := ben_ext_person.g_chg_pay_column;

547: END IF;
548: ----------- added in version 115.15
549: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
550: l_change_table := ben_ext_person.g_chg_pay_table;
551: l_change_column := ben_ext_person.g_chg_pay_column;
552: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
553:
554: debug('Calling the common include event proc');
555: l_include := pqp_gb_psi_functions.include_event

Line 552: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

548: ----------- added in version 115.15
549: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
550: l_change_table := ben_ext_person.g_chg_pay_table;
551: l_change_column := ben_ext_person.g_chg_pay_column;
552: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
553:
554: debug('Calling the common include event proc');
555: l_include := pqp_gb_psi_functions.include_event
556: (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date

Line 645: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

641: debug('g_office_address_changed: '||g_office_address_changed,10);
642: --
643: IF g_current_run = 'PERIODIC' THEN
644: g_office_address_changed := 'N';
645: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
646: l_change_table := ben_ext_person.g_chg_pay_table;
647: l_change_column := ben_ext_person.g_chg_pay_column;
648: debug('l_chg_surrogate_key: '||l_chg_surrogate_key,20);
649: debug('l_change_table: '||l_change_table,20);

Line 646: l_change_table := ben_ext_person.g_chg_pay_table;

642: --
643: IF g_current_run = 'PERIODIC' THEN
644: g_office_address_changed := 'N';
645: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
646: l_change_table := ben_ext_person.g_chg_pay_table;
647: l_change_column := ben_ext_person.g_chg_pay_column;
648: debug('l_chg_surrogate_key: '||l_chg_surrogate_key,20);
649: debug('l_change_table: '||l_change_table,20);
650: debug('l_change_column: '||l_change_column,20);

Line 647: l_change_column := ben_ext_person.g_chg_pay_column;

643: IF g_current_run = 'PERIODIC' THEN
644: g_office_address_changed := 'N';
645: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
646: l_change_table := ben_ext_person.g_chg_pay_table;
647: l_change_column := ben_ext_person.g_chg_pay_column;
648: debug('l_chg_surrogate_key: '||l_chg_surrogate_key,20);
649: debug('l_change_table: '||l_change_table,20);
650: debug('l_change_column: '||l_change_column,20);
651: debug('g_current_run: '||g_current_run,20);

Line 741: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

737: debug('g_home_address_changed: '||g_home_address_changed,10);
738: --
739: IF g_current_run = 'PERIODIC' THEN
740: g_home_address_changed := 'N';
741: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
742: l_change_table := ben_ext_person.g_chg_pay_table;
743: l_change_column := ben_ext_person.g_chg_pay_column;
744: debug('l_chg_surrogate_key: '||l_chg_surrogate_key,20);
745: debug('l_change_table: '||l_change_table,20);

Line 742: l_change_table := ben_ext_person.g_chg_pay_table;

738: --
739: IF g_current_run = 'PERIODIC' THEN
740: g_home_address_changed := 'N';
741: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
742: l_change_table := ben_ext_person.g_chg_pay_table;
743: l_change_column := ben_ext_person.g_chg_pay_column;
744: debug('l_chg_surrogate_key: '||l_chg_surrogate_key,20);
745: debug('l_change_table: '||l_change_table,20);
746: debug('l_change_column: '||l_change_column,20);

Line 743: l_change_column := ben_ext_person.g_chg_pay_column;

739: IF g_current_run = 'PERIODIC' THEN
740: g_home_address_changed := 'N';
741: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
742: l_change_table := ben_ext_person.g_chg_pay_table;
743: l_change_column := ben_ext_person.g_chg_pay_column;
744: debug('l_chg_surrogate_key: '||l_chg_surrogate_key,20);
745: debug('l_change_table: '||l_change_table,20);
746: debug('l_change_column: '||l_change_column,20);
747: debug('g_current_run: '||g_current_run,20);

Line 1680: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

1676: ELSE
1677: l_chg_surrogate_key := g_home_address_id;
1678: END IF;
1679: ELSE
1680: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1681: l_change_table := ben_ext_person.g_chg_pay_table;
1682: l_change_column := ben_ext_person.g_chg_pay_column;
1683: -- added in version 115.15
1684: IF UPPER(l_change_table) = 'PER_ADDRESSES'

Line 1681: l_change_table := ben_ext_person.g_chg_pay_table;

1677: l_chg_surrogate_key := g_home_address_id;
1678: END IF;
1679: ELSE
1680: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1681: l_change_table := ben_ext_person.g_chg_pay_table;
1682: l_change_column := ben_ext_person.g_chg_pay_column;
1683: -- added in version 115.15
1684: IF UPPER(l_change_table) = 'PER_ADDRESSES'
1685: AND g_person_addresses.exists(l_chg_surrogate_key)

Line 1682: l_change_column := ben_ext_person.g_chg_pay_column;

1678: END IF;
1679: ELSE
1680: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1681: l_change_table := ben_ext_person.g_chg_pay_table;
1682: l_change_column := ben_ext_person.g_chg_pay_column;
1683: -- added in version 115.15
1684: IF UPPER(l_change_table) = 'PER_ADDRESSES'
1685: AND g_person_addresses.exists(l_chg_surrogate_key)
1686: AND (g_person_addresses(l_chg_surrogate_key).address_type