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

Line 3352: 'ben_ext_person.g_effective_date: '

3348: DEBUG('p_effective_date: '
3349: || TO_CHAR(p_effective_date, 'DD/MON/YYYY'));
3350: DEBUG('p_assignment_id: ' || p_assignment_id);
3351: DEBUG(
3352: 'ben_ext_person.g_effective_date: '
3353: || TO_CHAR(ben_ext_person.g_effective_date, 'DD/MON/YYYY')
3354: );
3355: DEBUG(
3356: 'ben_ext_person.g_person_ext_dt: '

Line 3353: || TO_CHAR(ben_ext_person.g_effective_date, 'DD/MON/YYYY')

3349: || TO_CHAR(p_effective_date, 'DD/MON/YYYY'));
3350: DEBUG('p_assignment_id: ' || p_assignment_id);
3351: DEBUG(
3352: 'ben_ext_person.g_effective_date: '
3353: || TO_CHAR(ben_ext_person.g_effective_date, 'DD/MON/YYYY')
3354: );
3355: DEBUG(
3356: 'ben_ext_person.g_person_ext_dt: '
3357: || TO_CHAR(ben_ext_person.g_person_ext_dt, 'DD/MON/YYYY')

Line 3356: 'ben_ext_person.g_person_ext_dt: '

3352: 'ben_ext_person.g_effective_date: '
3353: || TO_CHAR(ben_ext_person.g_effective_date, 'DD/MON/YYYY')
3354: );
3355: DEBUG(
3356: 'ben_ext_person.g_person_ext_dt: '
3357: || TO_CHAR(ben_ext_person.g_person_ext_dt, 'DD/MON/YYYY')
3358: );
3359: END IF;
3360:

Line 3357: || TO_CHAR(ben_ext_person.g_person_ext_dt, 'DD/MON/YYYY')

3353: || TO_CHAR(ben_ext_person.g_effective_date, 'DD/MON/YYYY')
3354: );
3355: DEBUG(
3356: 'ben_ext_person.g_person_ext_dt: '
3357: || TO_CHAR(ben_ext_person.g_person_ext_dt, 'DD/MON/YYYY')
3358: );
3359: END IF;
3360:
3361: l_include_flag := 'N';

Line 3394: ,p_effective_date => ben_ext_person.g_effective_date

3390:
3391: -- set extract global variables
3392: set_earnings_history_globals(
3393: p_business_group_id => p_business_group_id
3394: ,p_effective_date => ben_ext_person.g_effective_date
3395: );
3396:
3397: IF g_debug
3398: THEN

Line 3586: IF g_effective_date <> ben_ext_person.g_person_ext_dt

3582:
3583: l_ni_category := NULL;
3584: l_effective_end_date := g_effective_end_date;
3585:
3586: IF g_effective_date <> ben_ext_person.g_person_ext_dt
3587: THEN
3588: l_effective_end_date :=
3589: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
3590: END IF;

Line 3589: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);

3585:
3586: IF g_effective_date <> ben_ext_person.g_person_ext_dt
3587: THEN
3588: l_effective_end_date :=
3589: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
3590: END IF;
3591:
3592: IF g_debug
3593: THEN

Line 3728: IF g_effective_date <> ben_ext_person.g_person_ext_dt

3724: END IF;
3725:
3726: l_effective_end_date := g_effective_end_date;
3727:
3728: IF g_effective_date <> ben_ext_person.g_person_ext_dt
3729: THEN
3730: l_effective_end_date :=
3731: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
3732: END IF;

Line 3731: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);

3727:
3728: IF g_effective_date <> ben_ext_person.g_person_ext_dt
3729: THEN
3730: l_effective_end_date :=
3731: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
3732: END IF;
3733:
3734: IF g_debug
3735: THEN

Line 4067: IF g_effective_date <> ben_ext_person.g_person_ext_dt

4063: THEN
4064: g_ayfwd_bal_conts := 0;
4065: END IF;
4066:
4067: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4068: THEN
4069: l_effective_end_date :=
4070: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4071: END IF;

Line 4070: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);

4066:
4067: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4068: THEN
4069: l_effective_end_date :=
4070: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4071: END IF;
4072:
4073: IF g_debug
4074: THEN

Line 4297: IF g_effective_date <> ben_ext_person.g_person_ext_dt

4293: END IF;
4294:
4295: l_effective_end_date := g_effective_end_date;
4296:
4297: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4298: THEN
4299: l_effective_end_date :=
4300: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4301: END IF;

Line 4300: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);

4296:
4297: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4298: THEN
4299: l_effective_end_date :=
4300: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4301: END IF;
4302:
4303: IF g_debug
4304: THEN

Line 4460: IF g_effective_date <> ben_ext_person.g_person_ext_dt

4456: l_total_add_yrs_contributions := 0;
4457: l_effective_end_date := g_effective_end_date;
4458:
4459:
4460: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4461: THEN
4462: l_effective_end_date :=
4463: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4464: END IF;

Line 4463: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);

4459:
4460: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4461: THEN
4462: l_effective_end_date :=
4463: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4464: END IF;
4465:
4466: IF g_debug
4467: THEN

Line 4657: IF g_effective_date <> ben_ext_person.g_person_ext_dt

4653: END IF;
4654:
4655: l_effective_end_date := g_effective_end_date;
4656:
4657: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4658: THEN
4659: l_effective_end_date :=
4660: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4661: END IF;

Line 4660: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);

4656:
4657: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4658: THEN
4659: l_effective_end_date :=
4660: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4661: END IF;
4662:
4663: IF g_debug
4664: THEN

Line 4845: IF g_effective_date <> ben_ext_person.g_person_ext_dt

4841: END IF;
4842:
4843: l_effective_end_date := g_effective_end_date;
4844:
4845: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4846: THEN
4847: l_effective_end_date :=
4848: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4849: END IF;

Line 4848: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);

4844:
4845: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4846: THEN
4847: l_effective_end_date :=
4848: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4849: END IF;
4850:
4851: IF g_debug
4852: THEN

Line 5044: IF g_effective_date <> ben_ext_person.g_person_ext_dt

5040: END IF;
5041:
5042: l_effective_end_date := g_effective_end_date;
5043:
5044: IF g_effective_date <> ben_ext_person.g_person_ext_dt
5045: THEN
5046: l_effective_end_date :=
5047: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
5048: END IF;

Line 5047: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);

5043:
5044: IF g_effective_date <> ben_ext_person.g_person_ext_dt
5045: THEN
5046: l_effective_end_date :=
5047: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
5048: END IF;
5049:
5050: IF g_debug
5051: THEN

Line 5218: IF g_effective_date <> ben_ext_person.g_person_ext_dt

5214: END IF;
5215:
5216: l_effective_end_date := g_effective_end_date;
5217:
5218: IF g_effective_date <> ben_ext_person.g_person_ext_dt
5219: THEN
5220: l_effective_end_date :=
5221: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
5222: END IF;

Line 5221: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);

5217:
5218: IF g_effective_date <> ben_ext_person.g_person_ext_dt
5219: THEN
5220: l_effective_end_date :=
5221: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
5222: END IF;
5223:
5224: IF g_debug
5225: THEN

Line 5426: IF g_effective_date <> ben_ext_person.g_person_ext_dt

5422: END IF;
5423:
5424: l_effective_end_date := g_effective_end_date;
5425:
5426: IF g_effective_date <> ben_ext_person.g_person_ext_dt
5427: THEN
5428: l_effective_end_date :=
5429: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
5430: END IF;

Line 5429: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);

5425:
5426: IF g_effective_date <> ben_ext_person.g_person_ext_dt
5427: THEN
5428: l_effective_end_date :=
5429: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
5430: END IF;
5431:
5432: IF g_debug
5433: THEN