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_NL_PGGM_PENSION_EXTRACTS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 68: per_assignment_status_types ast

64: ,paf.primary_flag
65: FROM per_all_assignments_f paf,
66: per_all_people_f per,
67: per_periods_of_service pps,
68: per_assignment_status_types ast
69: WHERE paf.assignment_id = c_assignment_id
70: AND paf.person_id = per.person_id
71: AND pps.period_of_service_id(+) = paf.period_of_service_id
72: AND ast.assignment_status_type_id = paf.assignment_status_type_id

Line 4057: per_assignment_status_types past

4053:
4054: CURSOR csr_get_sec_assgn_end_date(c_assignment_id NUMBER,c_business_group_id NUMBER) IS
4055: SELECT paa.effective_start_date
4056: FROM per_all_assignments_f paa,
4057: per_assignment_status_types past
4058: WHERE paa.assignment_id = c_assignment_id
4059: AND paa.business_group_id = c_business_group_id
4060: AND paa.assignment_status_type_id=past.assignment_status_type_id
4061: AND past.per_system_status ='TERM_ASSIGN'

Line 4072: FROM per_assignment_status_types

4068: SELECT MIN(effective_start_date)-1 term_date
4069: FROM per_all_assignments_f asg
4070: WHERE assignment_id = p_assignment_id
4071: AND assignment_status_type_id IN (SELECT assignment_status_type_id
4072: FROM per_assignment_status_types
4073: WHERE per_system_status = 'TERM_ASSIGN'
4074: AND active_flag = 'Y')
4075: UNION
4076: --

Line 4095: FROM per_assignment_status_types

4091: WHERE asg1.assignment_id = p_assignment_id
4092: AND asg1.effective_start_date < asg.effective_start_date
4093: AND asg.assignment_id = asg1.assignment_id
4094: AND asg1.assignment_status_type_id IN (SELECT assignment_status_type_id
4095: FROM per_assignment_status_types
4096: WHERE per_system_status = 'TERM_ASSIGN'
4097: AND active_flag = 'Y'));
4098: --
4099:

Line 6634: per_assignment_status_types past

6630: ,c_business_group_id IN Number
6631: ) IS
6632: SELECT min(paa.effective_start_date)
6633: FROM per_all_assignments_f paa,
6634: per_assignment_status_types past
6635: WHERE paa.assignment_id = c_assignment_id
6636: AND paa.business_group_id = c_business_group_id
6637: AND paa.assignment_status_type_id=past.assignment_status_type_id
6638: AND past.per_system_status ='TERM_ASSIGN';

Line 6742: per_assignment_status_types past

6738: ,c_business_group_id IN Number
6739: ) IS
6740: SELECT 'x'
6741: FROM per_all_assignments_f paa,
6742: per_assignment_status_types past
6743: WHERE paa.assignment_id = c_assignment_id
6744: AND paa.business_group_id = c_business_group_id
6745: AND paa.assignment_status_type_id=past.assignment_status_type_id
6746: AND past.per_system_status ='TERM_ASSIGN'

Line 6757: per_assignment_status_types past

6753: ,c_business_group_id IN Number
6754: ) IS
6755: SELECT paa.effective_end_date
6756: FROM per_all_assignments_f paa,
6757: per_assignment_status_types past
6758: WHERE paa.assignment_id = c_assignment_id
6759: AND paa.business_group_id = c_business_group_id
6760: AND paa.assignment_status_type_id=past.assignment_status_type_id
6761: AND past.per_system_status = 'TERM_ASSIGN';

Line 7115: per_assignment_status_types past

7111:
7112: CURSOR csr_chk_active_asg(c_asg_id NUMBER,bg_id NUMBER,eff_date DATE) IS
7113: SELECT 'x'
7114: FROM per_all_assignments_f paa,
7115: per_assignment_status_types past
7116: WHERE paa.assignment_id = c_asg_id
7117: AND paa.business_group_id = bg_id
7118: AND paa.assignment_status_type_id=past.assignment_status_type_id
7119: AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 7223: per_assignment_status_types past

7219:
7220: CURSOR csr_chk_active_asg(c_asg_id NUMBER,bg_id NUMBER,eff_date DATE) IS
7221: SELECT 'x'
7222: FROM per_all_assignments_f paa,
7223: per_assignment_status_types past
7224: WHERE paa.assignment_id = c_asg_id
7225: AND paa.business_group_id = bg_id
7226: AND paa.assignment_status_type_id=past.assignment_status_type_id
7227: AND past.per_system_status ='ACTIVE_ASSIGN'

Line 7233: per_assignment_status_types past

7229:
7230: CURSOR csr_chk_active_asg_period(c_asg_id NUMBER,bg_id NUMBER) IS
7231: SELECT 'x'
7232: FROM per_all_assignments_f paa,
7233: per_assignment_status_types past
7234: WHERE paa.assignment_id = c_asg_id
7235: AND paa.business_group_id = bg_id
7236: AND paa.assignment_status_type_id=past.assignment_status_type_id
7237: AND past.per_system_status ='ACTIVE_ASSIGN'

Line 7389: per_assignment_status_types past

7385:
7386: CURSOR csr_chk_active_asg(c_asg_id NUMBER,bg_id NUMBER,eff_date DATE) IS
7387: SELECT 'x'
7388: FROM per_all_assignments_f paa,
7389: per_assignment_status_types past
7390: WHERE paa.assignment_id = c_asg_id
7391: AND paa.business_group_id = bg_id
7392: AND paa.assignment_status_type_id=past.assignment_status_type_id
7393: AND past.per_system_status ='ACTIVE_ASSIGN'

Line 7399: per_assignment_status_types past

7395:
7396: CURSOR csr_chk_active_asg_period(c_asg_id NUMBER,bg_id NUMBER) IS
7397: SELECT 'x'
7398: FROM per_all_assignments_f paa,
7399: per_assignment_status_types past
7400: WHERE paa.assignment_id = c_asg_id
7401: AND paa.business_group_id = bg_id
7402: AND paa.assignment_status_type_id=past.assignment_status_type_id
7403: AND past.per_system_status ='ACTIVE_ASSIGN'