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

Line 93: per_assignment_status_types ast

89: ,paf.primary_flag
90: FROM per_all_assignments_f paf,
91: per_all_people_f per,
92: per_periods_of_service pps,
93: per_assignment_status_types ast
94: WHERE paf.assignment_id = c_assignment_id
95: AND paf.person_id = per.person_id
96: AND pps.period_of_service_id(+) = paf.period_of_service_id
97: AND ast.assignment_status_type_id = paf.assignment_status_type_id

Line 463: FROM per_assignment_status_types

459: AND asg.period_of_service_id = pps.period_of_service_id
460: AND (pps.actual_termination_date IS NULL
461: AND assignment_status_type_id IN
462: (SELECT assignment_status_type_id
463: FROM per_assignment_status_types
464: WHERE per_system_status = 'ACTIVE_ASSIGN'
465: AND active_flag = 'Y'))
466: AND p_effective_date BETWEEN effective_start_date
467: AND effective_end_date )

Line 484: FROM per_assignment_status_types

480: FROM per_all_assignments_f asg
481: WHERE assignment_id = p_assignment_id
482: AND effective_start_date <= g_extract_params(p_business_group_id).extract_end_date
483: AND assignment_status_type_id IN (SELECT assignment_status_type_id
484: FROM per_assignment_status_types
485: WHERE per_system_status = 'TERM_ASSIGN'
486: AND active_flag = 'Y')
487: group by period_of_service_id
488: UNION

Line 510: FROM per_assignment_status_types

506: WHERE asg1.assignment_id = p_assignment_id
507: AND asg1.effective_start_date < asg.effective_start_date
508: AND asg.assignment_id = asg1.assignment_id
509: AND asg1.assignment_status_type_id IN (SELECT assignment_status_type_id
510: FROM per_assignment_status_types
511: WHERE per_system_status = 'TERM_ASSIGN'
512: AND active_flag = 'Y'))
513: group by period_of_service_id
514: ;

Line 556: FROM per_assignment_status_types

552: ,period_of_service_id
553: FROM per_all_assignments_f asg
554: WHERE assignment_id = p_assignment_id
555: AND assignment_status_type_id IN (SELECT assignment_status_type_id
556: FROM per_assignment_status_types
557: WHERE per_system_status = 'TERM_ASSIGN'
558: AND active_flag = 'Y')
559: AND effective_start_date BETWEEN
560: g_extract_params(p_business_group_id).extract_start_date

Line 577: FROM per_assignment_status_types

573: AND effective_start_date <
574: g_extract_params(p_business_group_id).extract_start_date
575: AND asg.assignment_id = asg1.assignment_id
576: AND assignment_status_type_id IN (SELECT assignment_status_type_id
577: FROM per_assignment_status_types
578: WHERE per_system_status = 'TERM_ASSIGN'
579: AND active_flag = 'Y'))
580: ORDER BY effective_start_date )
581: UNION

Line 604: FROM per_assignment_status_types

600: AND effective_start_date <
601: g_extract_params(p_business_group_id).extract_start_date
602: AND asg.assignment_id = asg1.assignment_id
603: AND assignment_status_type_id IN (SELECT assignment_status_type_id
604: FROM per_assignment_status_types
605: WHERE per_system_status = 'TERM_ASSIGN'
606: AND active_flag = 'Y'))
607: AND NOT EXISTS ( SELECT 1
608: FROM ben_ext_chg_evt_log bec

Line 628: FROM per_assignment_status_types

624: WHERE assignment_id = p_assignment_id
625: AND asg.primary_flag = 'N'
626: AND effective_start_date < g_extract_params(p_business_group_id).extract_start_date
627: AND assignment_status_type_id IN (SELECT assignment_status_type_id
628: FROM per_assignment_status_types
629: WHERE per_system_status = 'TERM_ASSIGN'
630: AND active_flag = 'Y')
631: AND NOT EXISTS( SELECT 1
632: FROM ben_ext_rslt_dtl dtl

Line 1019: ,per_assignment_status_types past

1015: ,c_period_start in date
1016: ,c_period_end in date) IS
1017: SELECT COUNT(*)
1018: FROM per_assignments_f asg
1019: ,per_assignment_status_types past
1020: ,hr_soft_coding_keyflex target
1021: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
1022: AND past.per_system_status = 'ACTIVE_ASSIGN'
1023: AND asg.effective_start_date BETWEEN c_period_start

Line 1040: ,per_assignment_status_types past

1036: SELECT asg.effective_start_date Start_Date
1037: ,asg.effective_end_date End_Date
1038: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
1039: FROM per_assignments_f asg
1040: ,per_assignment_status_types past
1041: ,hr_soft_coding_keyflex target
1042: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
1043: AND past.per_system_status = 'ACTIVE_ASSIGN'
1044: AND asg.effective_start_date BETWEEN c_period_start

Line 2981: FROM per_assignment_status_types

2977: SELECT MIN(effective_start_date) - 1 term_date
2978: FROM per_all_assignments_f asg
2979: WHERE assignment_id = p_assignment_id
2980: AND assignment_status_type_id IN (SELECT assignment_status_type_id
2981: FROM per_assignment_status_types
2982: WHERE per_system_status = 'TERM_ASSIGN'
2983: AND active_flag = 'Y')
2984: UNION
2985: --

Line 3004: FROM per_assignment_status_types

3000: WHERE asg1.assignment_id = p_assignment_id
3001: AND asg1.effective_start_date < asg.effective_start_date
3002: AND asg.assignment_id = asg1.assignment_id
3003: AND asg1.assignment_status_type_id IN (SELECT assignment_status_type_id
3004: FROM per_assignment_status_types
3005: WHERE per_system_status = 'TERM_ASSIGN'
3006: AND active_flag = 'Y'))
3007: ;
3008:

Line 3195: ,per_assignment_status_types past

3191: ,effective_end_date end_date
3192: ,fnd_number.canonical_to_number(new_val1) ptp
3193: FROM per_all_assignments_f asg,
3194: ben_ext_chg_evt_log log
3195: ,per_assignment_status_types past
3196: ,hr_soft_coding_keyflex sck
3197: WHERE asg.assignment_id = p_assignment_id
3198: AND asg.assignment_status_type_id = past.assignment_status_type_id
3199: AND sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 3384: ,per_assignment_status_types past

3380: ,effective_start_date start_date
3381: ,effective_end_date end_date
3382: ,least(fnd_number.canonical_to_number(nvl(sck.segment29,100)),125) ptp
3383: FROM per_all_assignments_f asg
3384: ,per_assignment_status_types past
3385: ,hr_soft_coding_keyflex sck
3386: WHERE asg.assignment_id = p_assignment_id
3387: AND asg.assignment_status_type_id = past.assignment_status_type_id
3388: AND sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 3400: ,per_assignment_status_types past

3396:
3397: CURSOR c_get_min_st_dt IS
3398: SELECT effective_start_date
3399: FROM per_all_assignments_f asg
3400: ,per_assignment_status_types past
3401: ,hr_soft_coding_keyflex sck
3402: WHERE asg.assignment_id = p_assignment_id
3403: AND asg.assignment_status_type_id = past.assignment_status_type_id
3404: AND sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 3411: ,per_assignment_status_types past1

3407: g_extract_params(p_business_group_id).extract_start_date
3408: AND g_extract_params(p_business_group_id).extract_end_date
3409: AND EXISTS (SELECT 1
3410: FROM per_all_assignments_f asg1
3411: ,per_assignment_status_types past1
3412: ,hr_soft_coding_keyflex sck1
3413: WHERE asg1.assignment_id = p_assignment_id
3414: AND asg1.effective_end_date = asg.effective_start_date - 1
3415: AND asg1.assignment_status_type_id = past1.assignment_status_type_id

Line 3428: FROM per_assignment_status_types

3424: SELECT MIN(effective_start_date) hire_date
3425: FROM per_all_assignments_f asg
3426: WHERE assignment_id = p_assignment_id
3427: AND assignment_status_type_id IN (SELECT assignment_status_type_id
3428: FROM per_assignment_status_types
3429: WHERE per_system_status = 'ACTIVE_ASSIGN'
3430: AND active_flag = 'Y')
3431: AND assignment_type = 'E';
3432:

Line 3438: FROM per_assignment_status_types

3434: SELECT MIN(effective_start_date) - 1 term_date
3435: FROM per_all_assignments_f asg
3436: WHERE assignment_id = p_assignment_id
3437: AND assignment_status_type_id IN (SELECT assignment_status_type_id
3438: FROM per_assignment_status_types
3439: WHERE per_system_status = 'TERM_ASSIGN'
3440: AND active_flag = 'Y')
3441: AND assignment_type = 'E';
3442:

Line 7495: FROM per_assignments_f asg,per_assignment_status_types past

7491: ) RETURN NUMBER IS
7492:
7493: CURSOR cur_get_asg_start_date(c_assign_id IN NUMBER) IS
7494: SELECT MIN(asg.effective_start_date)
7495: FROM per_assignments_f asg,per_assignment_status_types past
7496: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
7497: AND past.per_system_status = 'ACTIVE_ASSIGN'
7498: AND asg.assignment_id = c_assign_id;
7499:

Line 10719: ,per_assignment_status_types past

10715: ,asg.effective_end_date End_Date
10716: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
10717: FROM per_assignments_f asg
10718: ,hr_soft_coding_keyflex target
10719: ,per_assignment_status_types past
10720: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
10721: AND asg.assignment_id = c_asg_id
10722: AND target.enabled_flag = 'Y'
10723: AND asg.assignment_status_type_id = past.assignment_status_type_id

Line 10868: ,per_assignment_status_types past

10864: ,c_eff_date IN DATE ) IS
10865: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
10866: FROM per_assignments_f asg
10867: ,hr_soft_coding_keyflex target
10868: ,per_assignment_status_types past
10869: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
10870: AND asg.assignment_id = c_asg_id
10871: AND target.enabled_flag = 'Y'
10872: AND asg.assignment_status_type_id = past.assignment_status_type_id

Line 10892: FROM per_assignment_status_types

10888: SELECT MIN(effective_start_date) - 1 term_date
10889: FROM per_all_assignments_f asg
10890: WHERE assignment_id = p_assignment_id
10891: AND assignment_status_type_id IN (SELECT assignment_status_type_id
10892: FROM per_assignment_status_types
10893: WHERE per_system_status = 'TERM_ASSIGN'
10894: AND active_flag = 'Y')
10895: AND assignment_type = 'E';*/
10896: