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.PAY_PL_PAYE_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 43: from per_all_assignments_f paaf,

39: and p_contract_category = 'NORMAL';
40:
41: cursor cur_asg is select nvl(assignment_eff_start_date,term_eff_start_date) effective_start_date from
42: (select min(paaf.effective_start_date) assignment_eff_start_date
43: from per_all_assignments_f paaf,
44: hr_soft_coding_keyflex scl,
45: per_assignment_status_types past
46: where paaf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID
47: and paaf.SOFT_CODING_KEYFLEX_ID = scl.SOFT_CODING_KEYFLEX_ID

Line 51: paaf.effective_start_date from per_all_assignments_f paaf,

47: and paaf.SOFT_CODING_KEYFLEX_ID = scl.SOFT_CODING_KEYFLEX_ID
48: and paaf.assignment_id = p_per_or_asg_id
49: and paaf.business_group_id = p_business_group_id
50: and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN') and not exists ( select
51: paaf.effective_start_date from per_all_assignments_f paaf,
52: per_assignment_status_types past
53: where paaf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID
54: and past.per_system_status = 'TERM_ASSIGN'
55: and paaf.assignment_id = p_per_or_asg_id

Line 58: (select min(paaf.effective_start_date) term_eff_start_date from per_all_assignments_f paaf,

54: and past.per_system_status = 'TERM_ASSIGN'
55: and paaf.assignment_id = p_per_or_asg_id
56: and paaf.business_group_id = p_business_group_id
57: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date)),
58: (select min(paaf.effective_start_date) term_eff_start_date from per_all_assignments_f paaf,
59: per_assignment_status_types past
60: where paaf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID
61: and past.per_system_status = 'TERM_ASSIGN'
62: and paaf.assignment_id = p_per_or_asg_id

Line 592: from per_all_assignments_f paf

588:
589: cursor csr_get_derived_details is
590: select bus.business_group_id
591: , bus.legislation_code
592: from per_all_assignments_f paf
593: , per_business_groups_perf bus
594: where paf.assignment_id = p_assignment_id
595: and l_effective_date between paf.effective_start_date
596: and paf.effective_end_date

Line 686: from per_all_assignments_f paf

682:
683: cursor csr_get_derived_details is
684: select bus.business_group_id
685: , bus.legislation_code
686: from per_all_assignments_f paf
687: , per_business_groups_perf bus
688: where paf.assignment_id = p_assignment_id
689: and l_effective_date between paf.effective_start_date
690: and paf.effective_end_date

Line 695: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf

691: and bus.business_group_id = paf.business_group_id;
692:
693: cursor csr_contract_type is
694: select segment4
695: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf
696: where soft.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
697: and paaf.assignment_id = p_assignment_id
698: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
699:

Line 801: from per_all_assignments_f paf

797:
798: cursor csr_get_derived_details is
799: select bus.business_group_id
800: , bus.legislation_code
801: from per_all_assignments_f paf
802: , per_business_groups_perf bus
803: where paf.assignment_id = p_assignment_id
804: and l_effective_date between paf.effective_start_date
805: and paf.effective_end_date