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_AE_GENERAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 39: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

35: -- This function return NOMATCH If the value for HR: Local Nationality
36: -- Profile does not match with the person's nationality else it retuns MATCH.
37: ------------------------------------------------------------------------
38: function local_nationality_matches
39: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
40: p_date_earned IN Date)
41: return varchar2
42: is
43: begin

Line 47: From PER_ALL_ASSIGNMENTS_F

43: begin
44: BEGIN
45: Select person_id
46: Into l_person_id
47: From PER_ALL_ASSIGNMENTS_F
48: Where ASSIGNMENT_ID = p_assignment_id
49: AND p_date_earned between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
50: EXCEPTION
51: WHEN no_data_found Then

Line 88: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

84: -- Function GET_PERSON_NATIONALITY
85: -- This function returns the person's nationality
86: ------------------------------------------------------------------------
87: function get_person_nationality
88: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
89: p_date_earned IN Date) return varchar2
90: is
91: l_nationality hr_lookups.meaning%type;
92: l_nationality_person per_all_people_f.nationality%type;

Line 100: From PER_ALL_ASSIGNMENTS_F

96: -- hr_utility.set_location('Entering: ' , 10);
97:
98: Select person_id
99: Into l_person_id
100: From PER_ALL_ASSIGNMENTS_F
101: Where ASSIGNMENT_ID = p_assignment_id
102: AND p_date_earned between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
103: hr_utility.set_location('l_person_id: '||l_person_id , 10);
104:

Line 301: FROM per_all_assignments_f paf

297: FUNCTION chk_multiple_assignments(p_effective_date IN DATE
298: ,p_person_id IN NUMBER) RETURN VARCHAR2 AS
299: CURSOR get_multiple_assgts IS
300: SELECT count(DISTINCT paf.assignment_id)
301: FROM per_all_assignments_f paf
302: ,per_assignment_status_types pas
303: WHERE paf.assignment_type = 'E'
304: AND paf.PERSON_ID = p_person_id
305: AND p_effective_date between effective_start_date and effective_end_date

Line 449: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

445: ------------------------------------------------------------------------
446: -- Function get_contract
447: ------------------------------------------------------------------------
448: FUNCTION get_contract
449: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
450: p_date_earned IN Date)
451: RETURN VARCHAR2 IS
452: l_contract VARCHAR2(30);
453: BEGIN

Line 458: ,per_all_assignments_f asg

454: BEGIN
455: SELECT cont.type
456: INTO l_contract
457: FROM per_contracts_f cont
458: ,per_all_assignments_f asg
459: WHERE asg.assignment_id = p_assignment_id
460: AND asg.contract_id = cont.contract_id
461: AND p_date_earned BETWEEN asg.effective_start_date AND asg.effective_end_date
462: AND p_date_earned BETWEEN cont.effective_start_date AND cont.effective_end_date;

Line 477: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

473: -- Function get_probation_period
474: --------------------------------------------------------------------------------------
475:
476: FUNCTION get_probation_period
477: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
478: p_date_earned IN Date)
479: RETURN date IS
480: l_date_probation_end date;
481: BEGIN

Line 485: FROM per_all_assignments_f asg

481: BEGIN
482: BEGIN
483: SELECT DATE_PROBATION_END
484: INTO l_date_probation_end
485: FROM per_all_assignments_f asg
486: WHERE asg.assignment_id = p_assignment_id
487: AND p_date_earned BETWEEN asg.effective_start_date AND asg.effective_end_date;
488: EXCEPTION
489: WHEN OTHERS THEN

Line 502: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

498: ------------------------------------------------------------------------
499: -- Function get_contract_expiry_status
500: ------------------------------------------------------------------------
501: FUNCTION get_contract_expiry_status
502: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
503: p_date_earned IN Date)
504: RETURN VARCHAR2 IS
505: l_contract VARCHAR2(30);
506: l_expiry_date DATE;

Line 515: ,per_all_assignments_f asg

511:
512: SELECT cont.type, fnd_date.canonical_to_date(cont.ctr_information2)
513: INTO l_contract, l_expiry_date
514: FROM per_contracts_f cont
515: ,per_all_assignments_f asg
516: WHERE asg.assignment_id = p_assignment_id
517: AND asg.contract_id = cont.contract_id
518: AND p_date_earned BETWEEN asg.effective_start_date AND asg.effective_end_date
519: AND p_date_earned BETWEEN cont.effective_start_date AND cont.effective_end_date;

Line 539: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

535: ------------------------------------------------------------------------
536: -- Function get_termination_initiator
537: ------------------------------------------------------------------------
538: function get_termination_initiator
539: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
540: p_date_earned IN Date)
541: RETURN VARCHAR2 IS
542: l_leav_reason per_periods_of_service.leaving_reason%TYPE;
543: l_initiator VARCHAR2(20);

Line 549: FROM per_all_assignments_f assign

545: l_initiator :='EE';
546: BEGIN
547: SELECT pos.leaving_reason
548: INTO l_leav_reason
549: FROM per_all_assignments_f assign
550: ,per_periods_of_service pos
551: WHERE p_date_earned BETWEEN assign.effective_start_date AND assign.effective_end_date
552: AND assign.assignment_id = p_assignment_id
553: AND assign.period_of_service_id = pos.period_of_service_id;

Line 586: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

582: ------------------------------------------------------------------------
583: -- Function user_gratuity_formula_exists
584: ------------------------------------------------------------------------
585: FUNCTION user_gratuity_formula_exists
586: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
587: p_date_earned IN Date)
588: RETURN VARCHAR2 IS
589: cursor csr_get_formula_id is
590: select HOI2.org_information1

Line 595: ,per_all_assignments_f PAA

591: from hr_organization_units HOU
592: ,hr_organization_information HOI1
593: ,hr_organization_information HOI2
594: ,hr_soft_coding_keyflex HSCK
595: ,per_all_assignments_f PAA
596: where HOU.business_group_id = PAA.business_group_id
597: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
598: to_date('4712/12/31','YYYY/MM/DD'))
599: and HOU.organization_id = HOI1.organization_id

Line 701: ,per_all_assignments_f PAA

697: from hr_organization_units HOU
698: ,hr_organization_information HOI1
699: ,hr_organization_information HOI2
700: ,hr_soft_coding_keyflex HSCK
701: ,per_all_assignments_f PAA
702: where HOU.business_group_id = PAA.business_group_id
703: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
704: to_date('4712/12/31','YYYY/MM/DD'))
705: and HOU.organization_id = HOI1.organization_id

Line 787: ,per_all_assignments_f PAA

783: from hr_organization_units HOU
784: ,hr_organization_information HOI1
785: ,hr_organization_information HOI2
786: ,hr_soft_coding_keyflex HSCK
787: ,per_all_assignments_f PAA
788: where HOU.business_group_id = PAA.business_group_id
789: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
790: to_date('4712/12/31','YYYY/MM/DD'))
791: and HOU.organization_id = HOI1.organization_id

Line 873: ,per_all_assignments_f asg

869: SELECT SUM(paa.absence_days) --(NVL(paa.absence_days, (paa.DATE_END - paa.DATE_START))
870: INTO l_days
871: FROM per_absence_attendances paa
872: ,per_absence_attendance_types paat
873: ,per_all_assignments_f asg
874: WHERE paat.absence_category ='UL'
875: AND paat.business_group_id = paa.business_group_id
876: AND paat.business_group_id = p_business_group_id
877: AND paat.absence_attendance_type_id = paa.absence_attendance_type_id

Line 907: ,per_all_assignments_f PAA

903: from hr_organization_units HOU
904: ,hr_organization_information HOI1
905: ,hr_organization_information HOI2
906: ,hr_soft_coding_keyflex HSCK
907: ,per_all_assignments_f PAA
908: where HOU.business_group_id = PAA.business_group_id
909: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
910: to_date('4712/12/31','YYYY/MM/DD'))
911: and HOU.organization_id = HOI1.organization_id