APPS.PAY_GB_EDI_P46_CAR dependencies on HR_GENERAL

Line 2933: substr(hr_general.decode_lookup('GB_COUNTY',

2929: SELECT addr.address_line1,
2930: addr.address_line2,
2931: addr.address_line3,
2932: addr.town_or_city,
2933: substr(hr_general.decode_lookup('GB_COUNTY',
2934: addr.region_1), 1, 35) region_1,
2935: addr.country,
2936: addr.postal_code
2937: FROM per_addresses addr

Line 3884: if private_flag_iterator.effective_end_date = hr_general.END_OF_TIME then

3880: -- if the private_use_flag is set to N -Y or Y- N, the allocation
3881: -- end date will be EOT. If it is EOT, Set it to the Withdrawal Date to
3882: -- avoid the error 'Date Car Withdrawn must not be later than Date of Message'
3883:
3884: if private_flag_iterator.effective_end_date = hr_general.END_OF_TIME then
3885: private_flag_iterator.effective_end_date := private_flag_iterator.effective_start_date;
3886: end if;
3887:
3888: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,

Line 4383: if private_flag_iterator.effective_end_date = hr_general.END_OF_TIME then

4379: -- if the private_use_flag is set to N -Y or Y- N, the allocation
4380: -- end date will be EOT. If it is EOT, Set it to the Withdrawal Date to
4381: -- avoid the error 'Date Car Withdrawn must not be later than Date of Message'
4382:
4383: if private_flag_iterator.effective_end_date = hr_general.END_OF_TIME then
4384: private_flag_iterator.effective_end_date := private_flag_iterator.effective_start_date;
4385: end if;
4386:
4387: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,

Line 4890: if private_flag_iterator.effective_end_date = hr_general.END_OF_TIME then

4886: -- if the private_use_flag is set to N -Y or Y- N, the allocation
4887: -- end date will be EOT. If it is EOT, Set it to the Withdrawal Date to
4888: -- avoid the error 'Date Car Withdrawn must not be later than Date of Message'
4889:
4890: if private_flag_iterator.effective_end_date = hr_general.END_OF_TIME then
4891: private_flag_iterator.effective_end_date := private_flag_iterator.effective_start_date;
4892: end if;
4893:
4894: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,