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_IN_UTILS dependencies on PER_ASSIGNMENTS_F

Line 465: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

461: --------------------------------------------------------------------------
462: -- 1.0 30/12/02 puchil Created this function --
463: --------------------------------------------------------------------------
464: FUNCTION get_person_id
465: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
466: ,p_effective_date IN DATE default null)
467: RETURN per_assignments_f.person_id%TYPE
468: IS
469: --

Line 467: RETURN per_assignments_f.person_id%TYPE

463: --------------------------------------------------------------------------
464: FUNCTION get_person_id
465: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
466: ,p_effective_date IN DATE default null)
467: RETURN per_assignments_f.person_id%TYPE
468: IS
469: --
470: CURSOR csr_person_details(c_effective_date IN DATE)
471: IS

Line 473: FROM per_assignments_f

469: --
470: CURSOR csr_person_details(c_effective_date IN DATE)
471: IS
472: SELECT person_id
473: FROM per_assignments_f
474: WHERE assignment_id = p_assignment_id
475: AND c_effective_date BETWEEN effective_start_date
476: AND effective_end_date;
477: --

Line 480: l_person_id per_assignments_f.person_id%TYPE;

476: AND effective_end_date;
477: --
478: l_proc VARCHAR2(100);
479: l_effective_date DATE;
480: l_person_id per_assignments_f.person_id%TYPE;
481: --
482: BEGIN
483: --
484: l_proc := g_package||'get_person_id';

Line 540: RETURN per_assignments_f.assignment_id%TYPE

536: --------------------------------------------------------------------------
537: FUNCTION get_assignment_id
538: (p_person_id IN per_people_f.person_id%TYPE
539: ,p_effective_date IN DATE default null)
540: RETURN per_assignments_f.assignment_id%TYPE
541: IS
542: --
543: CURSOR csr_assignment_details(c_effective_date IN DATE)
544: IS

Line 546: FROM per_assignments_f

542: --
543: CURSOR csr_assignment_details(c_effective_date IN DATE)
544: IS
545: SELECT assignment_id
546: FROM per_assignments_f
547: WHERE person_id = p_person_id
548: AND c_effective_date BETWEEN effective_start_date
549: AND effective_end_date;
550: --

Line 553: l_assignment_id per_assignments_f.assignment_id%TYPE;

549: AND effective_end_date;
550: --
551: l_proc VARCHAR2(100);
552: l_effective_date DATE;
553: l_assignment_id per_assignments_f.assignment_id%TYPE;
554: --
555: BEGIN
556: --
557: l_proc := g_package||'.get_assignment_id';

Line 883: FROM per_assignments_f paf

879: ,hsc.segment9
880: ,hsc.segment10
881: ,hsc.segment11
882: ,hsc.segment12
883: FROM per_assignments_f paf
884: ,hr_soft_coding_keyflex hsc
885: WHERE paf.assignment_id = p_assignment_id
886: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
887: AND paf.business_group_id = p_business_group_id

Line 1008: FROM per_assignments_f

1004:
1005: CURSOR c_bg
1006: IS
1007: SELECT business_group_id
1008: FROM per_assignments_f
1009: where assignment_id = p_assignment_id
1010: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1011:
1012:

Line 1063: FROM per_assignments_f

1059: grade_id,
1060: location_id,
1061: pay_basis_id,
1062: employment_category
1063: FROM per_assignments_f
1064: WHERE assignment_id = p_assignment_id
1065: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1066:
1067:

Line 1195: FROM per_assignments_f assgn

1191: /*
1192: CURSOR csr_element_link_details
1193: IS
1194: SELECT link.element_link_id
1195: FROM per_assignments_f assgn
1196: , pay_element_links_f link
1197: , pay_element_types_f types
1198: WHERE assgn.assignment_id = p_assignment_id
1199: AND ((link.payroll_id IS NOT NULL AND link.payroll_id = assgn.payroll_id) OR

Line 1401: FROM per_assignments_f asg,

1397: IS
1398: CURSOR c_gre_id
1399: IS
1400: SELECT scl.segment1
1401: FROM per_assignments_f asg,
1402: hr_soft_coding_keyflex scl
1403: WHERE asg.assignment_id = p_assignment_id
1404: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1405: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 2326: FROM per_assignments_f

2322: IS
2323: CURSOR c_asg_bg_id
2324: IS
2325: SELECT 1
2326: FROM per_assignments_f
2327: WHERE assignment_id = p_assignment_id
2328: AND business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2329: ORDER BY effective_end_date DESC;
2330:

Line 2531: ,per_assignments_f paf

2527: IS
2528: SELECT MAX(pos.date_start)
2529: FROM per_periods_of_service pos
2530: ,per_people_f ppf
2531: ,per_assignments_f paf
2532: WHERE pos.person_id = ppf.person_id
2533: AND ppf.person_id = paf.person_id
2534: AND pos.date_start between paf.effective_start_date and paf.effective_end_date
2535: AND paf.assignment_id = p_assignment_id;

Line 2568: per_assignments_f asg

2564: CURSOR csr_positions
2565: IS
2566: SELECT pos.name
2567: FROM per_positions pos,
2568: per_assignments_f asg
2569: WHERE pos.position_id = asg.position_id
2570: AND asg.assignment_id = p_assignment_id
2571: AND p_effective_date BETWEEN asg.effective_start_date
2572: AND asg.effective_end_date;