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 580: ,per_all_assignments_f paaf

576: ,pav.telephone_number_1 declarant_phone
577: ,papf.email_address declarant_email
578: ,pap.NAME declarant_position
579: from per_all_people_f papf
580: ,per_all_assignments_f paaf
581: ,per_all_positions pap
582: ,per_addresses_v pav
583: where papf.person_id=c_person_id ;
584: and paaf.person_id=papf.person_id

Line 906: l_assignment_number per_all_assignments_f.assignment_number%type;

902: chunk in number)
903: IS
904: l_assg_id per_assignments_f.assignment_id%TYPE;
905: l_person_id Number;
906: l_assignment_number per_all_assignments_f.assignment_number%type;
907: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
908:
909: l_prev_person_id Number := 0;
910: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;

Line 907: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;

903: IS
904: l_assg_id per_assignments_f.assignment_id%TYPE;
905: l_person_id Number;
906: l_assignment_number per_all_assignments_f.assignment_number%type;
907: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
908:
909: l_prev_person_id Number := 0;
910: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;
911:

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

906: l_assignment_number per_all_assignments_f.assignment_number%type;
907: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
908:
909: l_prev_person_id Number := 0;
910: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;
911:
912: l_start_date VARCHAR2(50);
913: l_end_date VARCHAR2(50);
914: l_select_str VARCHAR2(3000);

Line 963: from per_all_assignments_f paaf,

959:
960: hr_utility.set_location('Before building the dynamic query.',510);
961: /* 6856486 modified the employment_category 's IN condition to a value fetch from USER TABLE EHECS_ASG_CATG_TAB */
962: l_select_str :='select distinct paaf.assignment_id asgid
963: from per_all_assignments_f paaf,
964: per_all_people_f ppf,
965: pay_all_payrolls_f papf,
966: pay_payroll_actions ppa,
967: hr_soft_coding_keyflex scl

Line 1134: per_all_assignments_f paaf,

1130: ,frequency frequency /*6856473*/
1131: ,hourly_salaried_code hourly_or_salaried /*6856473*/
1132: ,papf.PERIOD_TYPE /* 9776525 */
1133: FROM
1134: per_all_assignments_f paaf,
1135: pay_all_payrolls_f papf -- 9776525
1136: WHERE paaf.assignment_id = c_assignment_id
1137: and paaf.person_id = c_person_id
1138: and paaf.effective_start_date <= g_qtr_end_date

Line 1189: l_normal_hours per_all_assignments_f.normal_hours%type;

1185: and hou.business_group_id= c_bg_id;
1186: --l_hours_per_day csr_hours_per_day%rowtype;
1187: l_hours_per_day varchar2(10);
1188: l_org_id hr_organization_units.organization_id%type;
1189: l_normal_hours per_all_assignments_f.normal_hours%type;
1190: l_frequency per_all_assignments_f.frequency%type;
1191:
1192: /* 9776525 start */
1193: --

Line 1190: l_frequency per_all_assignments_f.frequency%type;

1186: --l_hours_per_day csr_hours_per_day%rowtype;
1187: l_hours_per_day varchar2(10);
1188: l_org_id hr_organization_units.organization_id%type;
1189: l_normal_hours per_all_assignments_f.normal_hours%type;
1190: l_frequency per_all_assignments_f.frequency%type;
1191:
1192: /* 9776525 start */
1193: --
1194: /* commented as a part of bug 10040939

Line 1195: CURSOR csr_paid_pay_periods (p_assignment_id per_all_assignments_f.assignment_id%type,

1191:
1192: /* 9776525 start */
1193: --
1194: /* commented as a part of bug 10040939
1195: CURSOR csr_paid_pay_periods (p_assignment_id per_all_assignments_f.assignment_id%type,
1196: p_payroll_id pay_all_payrolls.payroll_id%type) IS
1197: select count(ptp.time_period_id)
1198: from per_time_periods ptp,
1199: pay_payroll_actions ppa,

Line 1215: CURSOR csr_paid_pay_periods (p_assignment_id per_all_assignments_f.assignment_id%type,

1211: l_paid_pay_periods NUMBER :=1;
1212: --
1213: /* 9776525 end */
1214: /* 10040939 start */
1215: CURSOR csr_paid_pay_periods (p_assignment_id per_all_assignments_f.assignment_id%type,
1216: p_payroll_id pay_all_payrolls.payroll_id%type) IS
1217: select count(ptp.time_period_id)
1218: from per_time_periods ptp
1219: where ptp.payroll_id = p_payroll_id

Line 2039: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2035: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2036: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2037:
2038: l_person_id per_all_people_f.person_id%TYPE;
2039: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2040: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2041: l_object_action_id pay_temp_object_actions.object_action_id%TYPE;
2042:
2043: CURSOR C_Perid_Asgid(p_payroll_action_id NUMBER, p_object_action_id NUMBER) IS

Line 2046: ,per_all_assignments_f paa

2042:
2043: CURSOR C_Perid_Asgid(p_payroll_action_id NUMBER, p_object_action_id NUMBER) IS
2044: SELECT DISTINCT ppf.person_id, paa.assignment_id
2045: FROM per_all_people_f ppf
2046: ,per_all_assignments_f paa
2047: ,pay_payroll_actions ppa
2048: ,pay_temp_object_actions ptoa
2049: WHERE paa.business_group_id = ppa.business_group_id
2050: AND paa.person_id = ppf.person_id

Line 2682: per_all_assignments_f paaf,

2678: )
2679: ) EHECS_CATG,
2680: paaf.assignment_id
2681: from
2682: per_all_assignments_f paaf,
2683: pay_all_payrolls_f papf,
2684: hr_soft_coding_keyflex scl
2685: where
2686: paaf.business_group_id = g_business_group_id

Line 2793: per_all_assignments_f paaf,

2789: )
2790: ) EHECS_CATG,
2791: paaf.assignment_id
2792: from
2793: per_all_assignments_f paaf,
2794: pay_all_payrolls_f papf,
2795: hr_soft_coding_keyflex scl
2796: where
2797: paaf.business_group_id = g_business_group_id

Line 2906: per_all_assignments_f paaf,

2902: ) EHECS_CATG,
2903: paaf.assignment_id,
2904: pps.period_of_service_id
2905: from
2906: per_all_assignments_f paaf,
2907: pay_all_payrolls_f papf,
2908: hr_soft_coding_keyflex scl,
2909: per_periods_of_service pps
2910: where

Line 2997: per_all_assignments_f paaf,

2993: CURSOR csr_all_payrolls
2994: IS
2995: select distinct papf.payroll_id
2996: from
2997: per_all_assignments_f paaf,
2998: pay_all_payrolls_f papf,
2999: hr_soft_coding_keyflex scl
3000: where
3001: paaf.business_group_id = g_business_group_id

Line 3050: per_all_assignments_f paaf,

3046: )
3047: ) EHECS_CATG,
3048: paaf.assignment_id
3049: from
3050: per_all_assignments_f paaf,
3051: pay_all_payrolls_f papf,
3052: hr_soft_coding_keyflex scl
3053: where
3054: paaf.business_group_id = g_business_group_id