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 3176: 'ben_ext_person.g_effective_date: '

3172: DEBUG('p_effective_date: '
3173: || TO_CHAR(p_effective_date, 'DD/MON/YYYY'));
3174: DEBUG('p_assignment_id: ' || p_assignment_id);
3175: DEBUG(
3176: 'ben_ext_person.g_effective_date: '
3177: || TO_CHAR(ben_ext_person.g_effective_date, 'DD/MON/YYYY')
3178: );
3179: DEBUG(
3180: 'ben_ext_person.g_person_ext_dt: '

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

3173: || TO_CHAR(p_effective_date, 'DD/MON/YYYY'));
3174: DEBUG('p_assignment_id: ' || p_assignment_id);
3175: DEBUG(
3176: 'ben_ext_person.g_effective_date: '
3177: || TO_CHAR(ben_ext_person.g_effective_date, 'DD/MON/YYYY')
3178: );
3179: DEBUG(
3180: 'ben_ext_person.g_person_ext_dt: '
3181: || TO_CHAR(ben_ext_person.g_person_ext_dt, 'DD/MON/YYYY')

Line 3180: 'ben_ext_person.g_person_ext_dt: '

3176: 'ben_ext_person.g_effective_date: '
3177: || TO_CHAR(ben_ext_person.g_effective_date, 'DD/MON/YYYY')
3178: );
3179: DEBUG(
3180: 'ben_ext_person.g_person_ext_dt: '
3181: || TO_CHAR(ben_ext_person.g_person_ext_dt, 'DD/MON/YYYY')
3182: );
3183: END IF;
3184:

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

3177: || TO_CHAR(ben_ext_person.g_effective_date, 'DD/MON/YYYY')
3178: );
3179: DEBUG(
3180: 'ben_ext_person.g_person_ext_dt: '
3181: || TO_CHAR(ben_ext_person.g_person_ext_dt, 'DD/MON/YYYY')
3182: );
3183: END IF;
3184:
3185: l_include_flag := 'N';

Line 3218: ,p_effective_date => ben_ext_person.g_effective_date

3214:
3215: -- set extract global variables
3216: set_earnings_history_globals(
3217: p_business_group_id => p_business_group_id
3218: ,p_effective_date => ben_ext_person.g_effective_date
3219: );
3220:
3221: IF g_debug
3222: THEN

Line 3395: IF g_effective_date <> ben_ext_person.g_person_ext_dt

3391:
3392: l_ni_category := NULL;
3393: l_effective_end_date := g_effective_end_date;
3394:
3395: IF g_effective_date <> ben_ext_person.g_person_ext_dt
3396: THEN
3397: l_effective_end_date :=
3398: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
3399: END IF;

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

3394:
3395: IF g_effective_date <> ben_ext_person.g_person_ext_dt
3396: THEN
3397: l_effective_end_date :=
3398: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
3399: END IF;
3400:
3401: IF g_debug
3402: THEN

Line 3537: IF g_effective_date <> ben_ext_person.g_person_ext_dt

3533: END IF;
3534:
3535: l_effective_end_date := g_effective_end_date;
3536:
3537: IF g_effective_date <> ben_ext_person.g_person_ext_dt
3538: THEN
3539: l_effective_end_date :=
3540: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
3541: END IF;

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

3536:
3537: IF g_effective_date <> ben_ext_person.g_person_ext_dt
3538: THEN
3539: l_effective_end_date :=
3540: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
3541: END IF;
3542:
3543: IF g_debug
3544: THEN

Line 3863: IF g_effective_date <> ben_ext_person.g_person_ext_dt

3859: THEN
3860: g_ayfwd_bal_conts := 0;
3861: END IF;
3862:
3863: IF g_effective_date <> ben_ext_person.g_person_ext_dt
3864: THEN
3865: l_effective_end_date :=
3866: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
3867: END IF;

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

3862:
3863: IF g_effective_date <> ben_ext_person.g_person_ext_dt
3864: THEN
3865: l_effective_end_date :=
3866: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
3867: END IF;
3868:
3869: IF g_debug
3870: THEN

Line 4093: IF g_effective_date <> ben_ext_person.g_person_ext_dt

4089: l_total_add_yrs_contributions := 0;
4090: l_effective_end_date := g_effective_end_date;
4091:
4092:
4093: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4094: THEN
4095: l_effective_end_date :=
4096: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4097: END IF;

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

4092:
4093: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4094: THEN
4095: l_effective_end_date :=
4096: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4097: END IF;
4098:
4099: IF g_debug
4100: THEN

Line 4290: IF g_effective_date <> ben_ext_person.g_person_ext_dt

4286: END IF;
4287:
4288: l_effective_end_date := g_effective_end_date;
4289:
4290: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4291: THEN
4292: l_effective_end_date :=
4293: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4294: END IF;

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

4289:
4290: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4291: THEN
4292: l_effective_end_date :=
4293: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4294: END IF;
4295:
4296: IF g_debug
4297: THEN

Line 4470: IF g_effective_date <> ben_ext_person.g_person_ext_dt

4466: END IF;
4467:
4468: l_effective_end_date := g_effective_end_date;
4469:
4470: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4471: THEN
4472: l_effective_end_date :=
4473: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4474: END IF;

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

4469:
4470: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4471: THEN
4472: l_effective_end_date :=
4473: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4474: END IF;
4475:
4476: IF g_debug
4477: THEN

Line 4661: IF g_effective_date <> ben_ext_person.g_person_ext_dt

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

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

4660:
4661: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4662: THEN
4663: l_effective_end_date :=
4664: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4665: END IF;
4666:
4667: IF g_debug
4668: THEN

Line 4826: IF g_effective_date <> ben_ext_person.g_person_ext_dt

4822: END IF;
4823:
4824: l_effective_end_date := g_effective_end_date;
4825:
4826: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4827: THEN
4828: l_effective_end_date :=
4829: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4830: END IF;

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

4825:
4826: IF g_effective_date <> ben_ext_person.g_person_ext_dt
4827: THEN
4828: l_effective_end_date :=
4829: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
4830: END IF;
4831:
4832: IF g_debug
4833: THEN

Line 5026: IF g_effective_date <> ben_ext_person.g_person_ext_dt

5022: END IF;
5023:
5024: l_effective_end_date := g_effective_end_date;
5025:
5026: IF g_effective_date <> ben_ext_person.g_person_ext_dt
5027: THEN
5028: l_effective_end_date :=
5029: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
5030: END IF;

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

5025:
5026: IF g_effective_date <> ben_ext_person.g_person_ext_dt
5027: THEN
5028: l_effective_end_date :=
5029: LEAST(g_effective_end_date, ben_ext_person.g_person_ext_dt);
5030: END IF;
5031:
5032: IF g_debug
5033: THEN