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

Line 943: l_assignment_number per_all_assignments_f.assignment_number%type;

939: chunk in number)
940: IS
941: l_assg_id per_assignments_f.assignment_id%TYPE;
942: l_person_id Number;
943: l_assignment_number per_all_assignments_f.assignment_number%type;
944: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
945:
946: l_prev_person_id Number := 0;
947: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;

Line 944: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;

940: IS
941: l_assg_id per_assignments_f.assignment_id%TYPE;
942: l_person_id Number;
943: l_assignment_number per_all_assignments_f.assignment_number%type;
944: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
945:
946: l_prev_person_id Number := 0;
947: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;
948:

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

943: l_assignment_number per_all_assignments_f.assignment_number%type;
944: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
945:
946: l_prev_person_id Number := 0;
947: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;
948:
949: l_start_date VARCHAR2(50);
950: l_end_date VARCHAR2(50);
951: l_select_str VARCHAR2(3000);

Line 1003: from per_all_assignments_f paaf,

999: hr_utility.set_location(' g_reference_start_date = '|| g_reference_start_date,505);
1000: hr_utility.set_location(' g_reference_end_date = '|| g_reference_end_date,505);
1001:
1002: l_select_str1 :='select count (distinct paaf.assignment_id )
1003: from per_all_assignments_f paaf,
1004: per_all_people_f ppf,
1005: pay_all_payrolls_f papf,
1006: pay_payroll_actions ppa,
1007: pay_assignment_actions paa,

Line 1059: from per_all_assignments_f paaf,

1055: l_select_str :='select asgid from (
1056: select asgid,round(mod(dbms_random.value*'||g_sample_fraction||','||g_sample_fraction||')) serial '
1057: || 'from ( '
1058: || 'select distinct paaf.assignment_id asgid
1059: from per_all_assignments_f paaf,
1060: per_all_people_f ppf,
1061: pay_all_payrolls_f papf,
1062: pay_payroll_actions ppa,
1063: pay_assignment_actions paa,

Line 1199: ,per_all_assignments_f paaf

1195:
1196: CURSOR cur_get_pactid(p_cess_aact pay_assignment_actions.assignment_action_id%TYPE) IS
1197: SELECT distinct paa.payroll_action_id,paa.assignment_id,paaf.person_id,papf.employee_number
1198: FROM pay_assignment_actions paa
1199: ,per_all_assignments_f paaf
1200: ,per_all_people_f papf -- 9795571
1201: WHERE paa.assignment_action_id = p_cess_aact
1202: and paa.assignment_id=paaf.assignment_id
1203: and papf.person_id=paaf.person_id; -- 9795571

Line 1212: ,per_all_assignments_f paaf

1208: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1209: paa.assignment_action_id),16))
1210: FROM pay_assignment_actions paa
1211: ,pay_payroll_actions ppa
1212: ,per_all_assignments_f paaf
1213: ,pay_all_payrolls_f papf
1214: ,hr_soft_coding_keyflex scl
1215: WHERE paaf.person_id=c_person_id
1216: AND paa.assignment_id=paaf.assignment_id

Line 1231: ,per_all_assignments_f paaf

1227: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1228: paa.assignment_action_id),16))
1229: FROM pay_assignment_actions paa
1230: ,pay_payroll_actions ppa
1231: ,per_all_assignments_f paaf
1232: ,pay_all_payrolls_f papf
1233: ,hr_soft_coding_keyflex scl
1234: WHERE paaf.person_id=c_person_id
1235: AND paa.assignment_id=paaf.assignment_id

Line 1285: per_all_assignments_f paaf

1281: ,hruserdt.get_table_value(paaf.business_group_id,'NES_ASG_CATG_TAB','Definite',paaf.EMPLOYMENT_CATEGORY,g_reference_start_date),'DEF'
1282: ,hruserdt.get_table_value(paaf.business_group_id,'NES_ASG_CATG_TAB','Apprentice_Trainee',paaf.EMPLOYMENT_CATEGORY,g_reference_start_date),'AT'
1283: ) NES_EMPLOYEMENT_CATG /* 10081528 */
1284: FROM
1285: per_all_assignments_f paaf
1286: WHERE paaf.assignment_id = c_assignment_id
1287: and paaf.person_id = c_person_id
1288: /* 9795685 */
1289: --

Line 1375: ,per_all_assignments_f paaf

1371: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1372: paa.assignment_action_id),16))
1373: FROM pay_assignment_actions paa
1374: ,pay_payroll_actions ppa
1375: ,per_all_assignments_f paaf
1376: ,pay_all_payrolls_f papf
1377: ,hr_soft_coding_keyflex scl
1378: WHERE paaf.person_id=c_person_id
1379: AND paa.assignment_id in (select paaf.assignment_id

Line 1380: from per_all_assignments_f paaf, per_assignment_extra_info paei

1376: ,pay_all_payrolls_f papf
1377: ,hr_soft_coding_keyflex scl
1378: WHERE paaf.person_id=c_person_id
1379: AND paa.assignment_id in (select paaf.assignment_id
1380: from per_all_assignments_f paaf, per_assignment_extra_info paei
1381: where paaf.person_id = c_person_id
1382: and paaf.assignment_id=paei.assignment_id
1383: and paei.information_type = 'IE_ASG_OVERRIDE'
1384: and paei.aei_information1 = c_ppsn_override --'314678745T'

Line 1401: ,per_all_assignments_f paaf

1397: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1398: paa.assignment_action_id),16))
1399: FROM pay_assignment_actions paa
1400: ,pay_payroll_actions ppa
1401: ,per_all_assignments_f paaf
1402: ,pay_all_payrolls_f papf
1403: ,hr_soft_coding_keyflex scl
1404: WHERE paaf.person_id=c_person_id
1405: AND paa.assignment_id in (select paaf.assignment_id

Line 1406: from per_all_assignments_f paaf, per_assignment_extra_info paei

1402: ,pay_all_payrolls_f papf
1403: ,hr_soft_coding_keyflex scl
1404: WHERE paaf.person_id=c_person_id
1405: AND paa.assignment_id in (select paaf.assignment_id
1406: from per_all_assignments_f paaf, per_assignment_extra_info paei
1407: where paaf.person_id = c_person_id
1408: and paaf.assignment_id=paei.assignment_id
1409: and paei.information_type = 'IE_ASG_OVERRIDE'
1410: and paei.aei_information1 = c_ppsn_override --'314678745T'

Line 1436: l_id_reference per_all_assignments_f.assignment_number%TYPE:=NULL;

1432: l_address_line3 hr_locations_all.address_line_3%type;
1433: l_address_line4 hr_locations_all.address_line_3%type;
1434: l_address_line5 hr_locations_all.address_line_3%type;
1435:
1436: l_id_reference per_all_assignments_f.assignment_number%TYPE:=NULL;
1437:
1438: l_valid_asg_rec cur_valid_asg%ROWTYPE;
1439: l_hours_per_day varchar2(10);
1440: l_org_id hr_organization_units.organization_id%type;

Line 1441: l_normal_hours per_all_assignments_f.normal_hours%type;

1437:
1438: l_valid_asg_rec cur_valid_asg%ROWTYPE;
1439: l_hours_per_day varchar2(10);
1440: l_org_id hr_organization_units.organization_id%type;
1441: l_normal_hours per_all_assignments_f.normal_hours%type;
1442: l_frequency per_all_assignments_f.frequency%type;
1443:
1444: Type tab_address is table of per_addresses.ADDRESS_LINE1%type index by binary_integer;
1445: pl_address tab_address;

Line 1442: l_frequency per_all_assignments_f.frequency%type;

1438: l_valid_asg_rec cur_valid_asg%ROWTYPE;
1439: l_hours_per_day varchar2(10);
1440: l_org_id hr_organization_units.organization_id%type;
1441: l_normal_hours per_all_assignments_f.normal_hours%type;
1442: l_frequency per_all_assignments_f.frequency%type;
1443:
1444: Type tab_address is table of per_addresses.ADDRESS_LINE1%type index by binary_integer;
1445: pl_address tab_address;
1446: pl_address_final tab_address;

Line 3067: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

3063: l_buf VARCHAR2(2000);
3064: l_proc VARCHAR2(100);
3065:
3066: l_person_id per_all_people_f.person_id%TYPE;
3067: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3068: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
3069: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3070:
3071: cursor csr_nes_emp_info (c_pact_id NUMBER) IS