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

Line 508: ,per_all_assignments_f paaf

504: ,pav.telephone_number_1 declarant_phone
505: ,papf.email_address declarant_email
506: ,pap.NAME declarant_position
507: from per_all_people_f papf
508: ,per_all_assignments_f paaf
509: ,per_all_positions pap
510: ,per_addresses_v pav
511: where papf.person_id=c_person_id ;
512: and paaf.person_id=papf.person_id

Line 732: l_assignment_number per_all_assignments_f.assignment_number%type;

728: chunk in number)
729: IS
730: l_assg_id per_assignments_f.assignment_id%TYPE;
731: l_person_id Number;
732: l_assignment_number per_all_assignments_f.assignment_number%type;
733: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
734:
735: l_prev_person_id Number := 0;
736: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;

Line 733: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;

729: IS
730: l_assg_id per_assignments_f.assignment_id%TYPE;
731: l_person_id Number;
732: l_assignment_number per_all_assignments_f.assignment_number%type;
733: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
734:
735: l_prev_person_id Number := 0;
736: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;
737:

Line 736: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;

732: l_assignment_number per_all_assignments_f.assignment_number%type;
733: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
734:
735: l_prev_person_id Number := 0;
736: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;
737:
738: l_start_date VARCHAR2(50);
739: l_end_date VARCHAR2(50);
740: l_select_str VARCHAR2(3000);

Line 789: from per_all_assignments_f paaf,

785:
786: hr_utility.set_location('Before building the dynamic query.',510);
787: /* 6856486 modified the employment_category 's IN condition to a value fetch from USER TABLE EHECS_ASG_CATG_TAB */
788: l_select_str :='select distinct paaf.assignment_id asgid
789: from per_all_assignments_f paaf,
790: per_all_people_f ppf,
791: pay_all_payrolls_f papf,
792: pay_payroll_actions ppa,
793: hr_soft_coding_keyflex scl

Line 959: per_all_assignments_f paaf

955: ,normal_hours normal_hours /*6856473*/
956: ,frequency frequency /*6856473*/
957: ,hourly_salaried_code hourly_or_salaried /*6856473*/
958: FROM
959: per_all_assignments_f paaf
960: WHERE paaf.assignment_id = c_assignment_id
961: and paaf.person_id = c_person_id
962: and paaf.effective_start_date <= g_qtr_end_date
963: and paaf.effective_end_date >= g_qtr_start_date

Line 1010: l_normal_hours per_all_assignments_f.normal_hours%type;

1006: and hou.business_group_id= c_bg_id;
1007: --l_hours_per_day csr_hours_per_day%rowtype;
1008: l_hours_per_day varchar2(10);
1009: l_org_id hr_organization_units.organization_id%type;
1010: l_normal_hours per_all_assignments_f.normal_hours%type;
1011: l_frequency per_all_assignments_f.frequency%type;
1012:
1013: --------------------------- Variables which will hold the Balance Values.
1014: l_regwg_bal_val Number := 0;

Line 1011: l_frequency per_all_assignments_f.frequency%type;

1007: --l_hours_per_day csr_hours_per_day%rowtype;
1008: l_hours_per_day varchar2(10);
1009: l_org_id hr_organization_units.organization_id%type;
1010: l_normal_hours per_all_assignments_f.normal_hours%type;
1011: l_frequency per_all_assignments_f.frequency%type;
1012:
1013: --------------------------- Variables which will hold the Balance Values.
1014: l_regwg_bal_val Number := 0;
1015: l_irrb_bal_val Number := 0;

Line 1756: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1752: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
1753: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1754:
1755: l_person_id per_all_people_f.person_id%TYPE;
1756: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1757: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1758: l_object_action_id pay_temp_object_actions.object_action_id%TYPE;
1759:
1760: CURSOR C_Perid_Asgid(p_payroll_action_id NUMBER, p_object_action_id NUMBER) IS

Line 1763: ,per_all_assignments_f paa

1759:
1760: CURSOR C_Perid_Asgid(p_payroll_action_id NUMBER, p_object_action_id NUMBER) IS
1761: SELECT DISTINCT ppf.person_id, paa.assignment_id
1762: FROM per_all_people_f ppf
1763: ,per_all_assignments_f paa
1764: ,pay_payroll_actions ppa
1765: ,pay_temp_object_actions ptoa
1766: WHERE paa.business_group_id = ppa.business_group_id
1767: AND paa.person_id = ppf.person_id

Line 2399: per_all_assignments_f paaf,

2395: )
2396: ) EHECS_CATG,
2397: paaf.assignment_id
2398: from
2399: per_all_assignments_f paaf,
2400: pay_all_payrolls_f papf,
2401: hr_soft_coding_keyflex scl
2402: where
2403: paaf.business_group_id = g_business_group_id

Line 2508: per_all_assignments_f paaf,

2504: )
2505: ) EHECS_CATG,
2506: paaf.assignment_id
2507: from
2508: per_all_assignments_f paaf,
2509: pay_all_payrolls_f papf,
2510: hr_soft_coding_keyflex scl
2511: where
2512: paaf.business_group_id = g_business_group_id

Line 2619: per_all_assignments_f paaf,

2615: ) EHECS_CATG,
2616: paaf.assignment_id,
2617: pps.period_of_service_id
2618: from
2619: per_all_assignments_f paaf,
2620: pay_all_payrolls_f papf,
2621: hr_soft_coding_keyflex scl,
2622: per_periods_of_service pps
2623: where

Line 2710: per_all_assignments_f paaf,

2706: CURSOR csr_all_payrolls
2707: IS
2708: select distinct papf.payroll_id
2709: from
2710: per_all_assignments_f paaf,
2711: pay_all_payrolls_f papf,
2712: hr_soft_coding_keyflex scl
2713: where
2714: paaf.business_group_id = g_business_group_id

Line 2763: per_all_assignments_f paaf,

2759: )
2760: ) EHECS_CATG,
2761: paaf.assignment_id
2762: from
2763: per_all_assignments_f paaf,
2764: pay_all_payrolls_f papf,
2765: hr_soft_coding_keyflex scl
2766: where
2767: paaf.business_group_id = g_business_group_id