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 1046: FROM per_assignments_f

1042: grade_id,
1043: location_id,
1044: pay_basis_id,
1045: employment_category
1046: FROM per_assignments_f
1047: WHERE assignment_id = p_assignment_id
1048: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1049:
1050:

Line 1180: FROM per_assignments_f assgn

1176: /*
1177: CURSOR csr_element_link_details
1178: IS
1179: SELECT link.element_link_id
1180: FROM per_assignments_f assgn
1181: , pay_element_links_f link
1182: , pay_element_types_f types
1183: WHERE assgn.assignment_id = p_assignment_id
1184: AND ((link.payroll_id IS NOT NULL AND link.payroll_id = assgn.payroll_id) OR

Line 1386: FROM per_assignments_f asg,

1382: IS
1383: CURSOR c_gre_id
1384: IS
1385: SELECT scl.segment1
1386: FROM per_assignments_f asg,
1387: hr_soft_coding_keyflex scl
1388: WHERE asg.assignment_id = p_assignment_id
1389: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1390: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 2311: FROM per_assignments_f

2307: IS
2308: CURSOR c_asg_bg_id
2309: IS
2310: SELECT 1
2311: FROM per_assignments_f
2312: WHERE assignment_id = p_assignment_id
2313: AND business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2314: ORDER BY effective_end_date DESC;
2315:

Line 2516: ,per_assignments_f paf

2512: IS
2513: SELECT MAX(pos.date_start)
2514: FROM per_periods_of_service pos
2515: ,per_people_f ppf
2516: ,per_assignments_f paf
2517: WHERE pos.person_id = ppf.person_id
2518: AND ppf.person_id = paf.person_id
2519: AND pos.date_start between paf.effective_start_date and paf.effective_end_date
2520: AND paf.assignment_id = p_assignment_id;

Line 2553: per_assignments_f asg

2549: CURSOR csr_positions
2550: IS
2551: SELECT pos.name
2552: FROM per_positions pos,
2553: per_assignments_f asg
2554: WHERE pos.position_id = asg.position_id
2555: AND asg.assignment_id = p_assignment_id
2556: AND p_effective_date BETWEEN asg.effective_start_date
2557: AND asg.effective_end_date;