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 1038: ,per_assignment_status_types past

1034: ,c_period_start in date
1035: ,c_period_end in date) IS
1036: SELECT COUNT(*)
1037: FROM per_assignments_f asg
1038: ,per_assignment_status_types past
1039: ,hr_soft_coding_keyflex target
1040: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
1041: AND past.per_system_status = 'ACTIVE_ASSIGN'
1042: AND asg.effective_start_date BETWEEN c_period_start

Line 1059: ,per_assignment_status_types past

1055: SELECT asg.effective_start_date Start_Date
1056: ,asg.effective_end_date End_Date
1057: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
1058: FROM per_assignments_f asg
1059: ,per_assignment_status_types past
1060: ,hr_soft_coding_keyflex target
1061: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
1062: AND past.per_system_status = 'ACTIVE_ASSIGN'
1063: AND asg.effective_start_date BETWEEN c_period_start

Line 3002: FROM per_assignment_status_types

2998: SELECT MIN(effective_start_date) - 1 term_date
2999: FROM per_all_assignments_f asg
3000: WHERE assignment_id = p_assignment_id
3001: AND assignment_status_type_id IN (SELECT assignment_status_type_id
3002: FROM per_assignment_status_types
3003: WHERE per_system_status = 'TERM_ASSIGN'
3004: AND active_flag = 'Y')
3005: UNION
3006: --

Line 3025: FROM per_assignment_status_types

3021: WHERE asg1.assignment_id = p_assignment_id
3022: AND asg1.effective_start_date < asg.effective_start_date
3023: AND asg.assignment_id = asg1.assignment_id
3024: AND asg1.assignment_status_type_id IN (SELECT assignment_status_type_id
3025: FROM per_assignment_status_types
3026: WHERE per_system_status = 'TERM_ASSIGN'
3027: AND active_flag = 'Y'))
3028: ;
3029:

Line 3216: ,per_assignment_status_types past

3212: ,effective_end_date end_date
3213: ,fnd_number.canonical_to_number(new_val1) ptp
3214: FROM per_all_assignments_f asg,
3215: ben_ext_chg_evt_log log
3216: ,per_assignment_status_types past
3217: ,hr_soft_coding_keyflex sck
3218: WHERE asg.assignment_id = p_assignment_id
3219: AND asg.assignment_status_type_id = past.assignment_status_type_id
3220: AND sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 3405: ,per_assignment_status_types past

3401: ,effective_start_date start_date
3402: ,effective_end_date end_date
3403: ,least(fnd_number.canonical_to_number(nvl(sck.segment29,100)),125) ptp
3404: FROM per_all_assignments_f asg
3405: ,per_assignment_status_types past
3406: ,hr_soft_coding_keyflex sck
3407: WHERE asg.assignment_id = p_assignment_id
3408: AND asg.assignment_status_type_id = past.assignment_status_type_id
3409: AND sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 3421: ,per_assignment_status_types past

3417:
3418: CURSOR c_get_min_st_dt IS
3419: SELECT effective_start_date
3420: FROM per_all_assignments_f asg
3421: ,per_assignment_status_types past
3422: ,hr_soft_coding_keyflex sck
3423: WHERE asg.assignment_id = p_assignment_id
3424: AND asg.assignment_status_type_id = past.assignment_status_type_id
3425: AND sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 3432: ,per_assignment_status_types past1

3428: g_extract_params(p_business_group_id).extract_start_date
3429: AND g_extract_params(p_business_group_id).extract_end_date
3430: AND EXISTS (SELECT 1
3431: FROM per_all_assignments_f asg1
3432: ,per_assignment_status_types past1
3433: ,hr_soft_coding_keyflex sck1
3434: WHERE asg1.assignment_id = p_assignment_id
3435: AND asg1.effective_end_date = asg.effective_start_date - 1
3436: AND asg1.assignment_status_type_id = past1.assignment_status_type_id

Line 3449: FROM per_assignment_status_types

3445: SELECT MIN(effective_start_date) hire_date
3446: FROM per_all_assignments_f asg
3447: WHERE assignment_id = p_assignment_id
3448: AND assignment_status_type_id IN (SELECT assignment_status_type_id
3449: FROM per_assignment_status_types
3450: WHERE per_system_status = 'ACTIVE_ASSIGN'
3451: AND active_flag = 'Y')
3452: AND assignment_type = 'E';
3453:

Line 3459: FROM per_assignment_status_types

3455: SELECT MIN(effective_start_date) - 1 term_date
3456: FROM per_all_assignments_f asg
3457: WHERE assignment_id = p_assignment_id
3458: AND assignment_status_type_id IN (SELECT assignment_status_type_id
3459: FROM per_assignment_status_types
3460: WHERE per_system_status = 'TERM_ASSIGN'
3461: AND active_flag = 'Y')
3462: AND assignment_type = 'E';
3463:

Line 7834: FROM per_assignments_f asg,per_assignment_status_types past

7830: ) RETURN NUMBER IS
7831:
7832: CURSOR cur_get_asg_start_date(c_assign_id IN NUMBER) IS
7833: SELECT MIN(asg.effective_start_date)
7834: FROM per_assignments_f asg,per_assignment_status_types past
7835: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
7836: AND past.per_system_status = 'ACTIVE_ASSIGN'
7837: AND asg.assignment_id = c_assign_id;
7838:

Line 11058: ,per_assignment_status_types past

11054: ,asg.effective_end_date End_Date
11055: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
11056: FROM per_assignments_f asg
11057: ,hr_soft_coding_keyflex target
11058: ,per_assignment_status_types past
11059: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
11060: AND asg.assignment_id = c_asg_id
11061: AND target.enabled_flag = 'Y'
11062: AND asg.assignment_status_type_id = past.assignment_status_type_id

Line 11207: ,per_assignment_status_types past

11203: ,c_eff_date IN DATE ) IS
11204: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
11205: FROM per_assignments_f asg
11206: ,hr_soft_coding_keyflex target
11207: ,per_assignment_status_types past
11208: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
11209: AND asg.assignment_id = c_asg_id
11210: AND target.enabled_flag = 'Y'
11211: AND asg.assignment_status_type_id = past.assignment_status_type_id

Line 11231: FROM per_assignment_status_types

11227: SELECT MIN(effective_start_date) - 1 term_date
11228: FROM per_all_assignments_f asg
11229: WHERE assignment_id = p_assignment_id
11230: AND assignment_status_type_id IN (SELECT assignment_status_type_id
11231: FROM per_assignment_status_types
11232: WHERE per_system_status = 'TERM_ASSIGN'
11233: AND active_flag = 'Y')
11234: AND assignment_type = 'E';*/
11235: