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

Line 4: g_param_issuing_estab_id per_all_assignments_f.establishment_id%type;

1: PACKAGE BODY PAY_FR_DADS_EMP_PKG as
2: /* $Header: pyfrdems.pkb 120.1 2006/03/16 10:29 aparkes noship $ */
3: g_package varchar2(50); -- Global package name
4: g_param_issuing_estab_id per_all_assignments_f.establishment_id%type;
5: g_param_company_id hr_organization_information.organization_id%type;
6: g_param_estab_id hr_organization_information.organization_id%type;
7: g_effective_date Date;
8: g_assign_action_id pay_payroll_actions.payroll_action_id%type;

Line 76: , per_all_assignments_f paf

72: , paf.location_id location_id--used to send as a parameter in s41 Structure
73: , paf.assignment_id assignment_id -- assignment_id , p_id
74: , ppf.employee_number employee_number -- this will be the id2 column
75: From per_all_people_f ppf
76: , per_all_assignments_f paf
77: , pay_assignment_actions paa
78: , per_addresses pa
79: , fnd_territories ft
80: , fnd_territories_tl ft_tl

Line 109: l_location_id per_all_assignments_f.location_id%type;

105: l_emp_rec cur_emp_data%rowtype;
106: l_name VARCHAR2(250);
107: l_person_id per_all_people_f.person_id%type;
108: l_address_id per_addresses.address_id%type;
109: l_location_id per_all_assignments_f.location_id%type;
110:
111: p_id Number;
112: l_id2 per_all_people_f.employee_number%type;
113: l_pactid pay_payroll_actions.payroll_action_id%type;

Line 689: from per_all_assignments_f asg

685: ,g_param_start_date) start_date
686: ,least(asg.effective_end_date, g_effective_date) end_date
687: ,paa.assignment_action_id
688: ,org_est.org_information1
689: from per_all_assignments_f asg
690: ,pay_assignment_actions paa
691: ,hr_soft_coding_keyflex scl
692: ,hr_organization_information org_est
693: where paa.assignment_action_id = g_assign_action_id

Line 714: from per_all_assignments_f asg

710: ,asg.effective_start_date effective_start_date
711: ,least(asg.effective_end_date, c_end_date) end_date
712: ,paa.assignment_action_id
713: ,org_est.org_information1
714: from per_all_assignments_f asg
715: ,pay_assignment_actions paa
716: ,hr_soft_coding_keyflex scl
717: ,hr_organization_information org_est
718: where paa.assignment_action_id = g_assign_action_id

Line 742: ,per_all_assignments_f asg

738: ,g_param_start_date) start_date
739: ,greatest(pee.effective_start_date, g_param_start_date) asg_start_date
740: ,least(pee.effective_end_Date, g_effective_date) end_date
741: from pay_element_entries_f pee
742: ,per_all_assignments_f asg
743: ,hr_organization_information org_est
744: ,pay_assignment_actions paa
745: where paa.assignment_action_id = g_assign_action_id
746: and pee.assignment_id = asg.assignment_id

Line 791: ,per_all_assignments_f asg

787: , pcf.contract_id contract_id
788: , asg.effective_start_date start_date
789: , least(pcf.effective_end_date, c_end_date) end_date
790: from pay_assignment_actions paa
791: ,per_all_assignments_f asg
792: ,per_contracts_f pcf
793: ,hr_organization_information org_est
794: where paa.assignment_action_id = g_assign_action_id
795: and org_est.org_information1 = p_org_id

Line 817: ,per_all_assignments_f asg

813: ,c_param_start_date) start_date
814: ,asg.effective_start_date asg_start_date
815: ,least(asg.effective_end_date,c_end_date) asg_end_date
816: From pay_assignment_actions paa
817: ,per_all_assignments_f asg
818: ,hr_organization_information org_est
819: where paa.assignment_action_id = g_assign_action_id
820: and asg.effective_start_date <= c_end_date
821: and asg.effective_start_date >= c_param_start_date

Line 839: ,per_all_assignments_f asg

835: Cursor csr_19(p_person_id number) IS
836: (select asg.establishment_id, org_est.org_information1 company_id
837: ,asg.effective_start_date start_date, 'FIRST' type
838: from pay_assignment_actions paa
839: ,per_all_assignments_f asg
840: ,hr_organization_information org_est
841: where paa.assignment_action_id = g_assign_action_id
842: and asg.assignment_id = paa.assignment_id
843: and asg.person_id = p_person_id

Line 853: ,per_all_assignments_f asg

849: -- Get all the changes in company id
850: (select asg.establishment_id, org_est.org_information1 company_id
851: ,asg.effective_start_date start_date, 'HIST' type
852: from pay_assignment_actions paa
853: ,per_all_assignments_f asg
854: ,hr_organization_information org_est
855: where paa.assignment_action_id = g_assign_action_id
856: and asg.assignment_id = paa.assignment_id
857: and asg.person_id = p_person_id

Line 872: ,per_all_assignments_f asg

868: Cursor csr_NIC(p_person_id Number, p_org_id Varchar2) IS
869: Select asg.effective_start_date start_date, asg.establishment_id
870: , substr(org_est.org_information2,length(org_est.org_information2)-4, 5)
871: From pay_assignment_actions paa
872: ,per_all_assignments_f asg
873: ,hr_organization_information org_est
874: Where paa.assignment_action_id = g_assign_action_id
875: and asg.assignment_id = paa.assignment_id
876: and asg.person_id = p_person_id

Line 901: From per_all_assignments_f asg

897: /* Getting the issuing establishment Name
898: ,hou_issue_estab_tl.name issue_estab_name
899: ,hloc_asg_estab_tl.location_code location_name
900: ,asg_estab_tl.name asg_estab_name
901: From per_all_assignments_f asg
902: ,pay_assignment_actions paa
903: ,hr_organization_information org_est
904: ,hr_all_organization_units hou
905: ,hr_locations_all hla

Line 946: ,per_all_assignments_f asg

942: ,hou_issue_estab_tl.name issue_estab_name
943: ,hloc_asg_estab_tl.location_code location_name
944: ,asg_estab_tl.name asg_estab_name
945: From pay_assignment_actions paa
946: ,per_all_assignments_f asg
947: ,hr_organization_information org_est
948: ,hr_locations_all hla
949: ,hr_locations_all_tl hloc_asg_estab_tl
950: ,hr_all_organization_units_tl hou_issue_estab_tl

Line 999: From per_all_assignments_f asg

995: , paf.full_name Name
996: , pca.CAG_INFORMATION1 col_aggr_code --S41.G01.00.016
997: , asg.assignment_id assignment_id -- used for fetch conventional classfication --S41.G01.00.017
998: /* DECODE(SEX, 'F', DECODE(NVL(PER_INFORMATION1, PREVIOUS_LAST_NAME), LAST_NAME, NULL,LAST_NAME) , 'M', DECODE( PREVIOUS_LAST_NAME, LAST_NAME, NULL, LAST_NAME)) Name --Getting the employee full name*/
999: From per_all_assignments_f asg
1000: ,pay_assignment_actions paa
1001: , per_jobs pj
1002: , per_all_people_f paf
1003: , per_contracts_f pc

Line 1032: , per_all_assignments_f asg

1028: Select pef.entry_information1 pension_info--Used in employment cat code
1029: From pay_element_entries_f pef
1030: , pay_element_links_f pel
1031: , pay_element_types_f pet
1032: , per_all_assignments_f asg
1033: , hr_organization_information org_est
1034: ,pay_assignment_actions paa
1035: Where paa.assignment_action_id = g_assign_action_id
1036: and pef.assignment_id = asg.assignment_id

Line 1077: ,per_all_assignments_f asg

1073: ,pps.Actual_termination_date term_date
1074: ,pps.Final_process_date final_date
1075: ,pps.Leaving_reason leav_reason
1076: From per_periods_of_service pps
1077: ,per_all_assignments_f asg
1078: ,hr_organization_information org_est
1079: ,pay_assignment_actions paa
1080: Where paa.assignment_action_id = g_assign_action_id
1081: and org_est.org_information1 = p_org_id

Line 1097: from per_all_assignments_f paf

1093: cursor c_assignment_cursor is
1094: select assignment_id
1095: ,greatest(g_param_start_date,effective_start_date) effective_start_date
1096: ,least(g_effective_date, effective_end_date) effective_end_date
1097: from per_all_assignments_f paf
1098: where person_id = p_person_id
1099: And g_effective_date Between effective_start_date And effective_end_date;
1100:
1101: c_assignment c_assignment_cursor%rowtype;

Line 1121: Cursor csr_fetch_conv_class(p_assignment_id per_all_assignments_f.assignment_id%type

1117:
1118:
1119: --Cursor to fetch Conventional Classification.....S41.G01.00.017
1120:
1121: Cursor csr_fetch_conv_class(p_assignment_id per_all_assignments_f.assignment_id%type
1122: ,p_effective_date DATE
1123: ,p_per_id Number)
1124: Is
1125: Select gqual.segment_attribute_type qualifier

Line 1128: per_all_assignments_f asg

1124: Is
1125: Select gqual.segment_attribute_type qualifier
1126: ,substr(CAGR.segment1,1,60) conv_classfication
1127: from
1128: per_all_assignments_f asg
1129: ,per_cagr_grades_def cagr
1130: ,fnd_id_flex_segments seg
1131: ,fnd_segment_attribute_values gqual
1132: where asg.assignment_id = p_assignment_id

Line 1275: l_estab_id per_all_assignments_f.establishment_id%type;

1271: l_old_coy hr_organization_information.organization_id%type;
1272: l_old_est hr_organization_information.organization_id%type;
1273: l_work_acc_rate pay_user_column_instances_f.value%type;
1274: l_siret_number VARCHAR2(10);
1275: l_estab_id per_all_assignments_f.establishment_id%type;
1276: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1277: l_contract_type VARCHAR2(50);
1278: l_contract_type_1 per_contracts_f.type%type;
1279: l_prof_code HR_SOFT_CODING_KEYFLEX.segment16%type;

Line 1284: l_frequency per_all_assignments_f.frequency%type;

1280: l_border_worker HR_SOFT_CODING_KEYFLEX.segment12%type;
1281: l_detache HR_SOFT_CODING_KEYFLEX.segment14%type;
1282: l_act_type per_contracts_f.type%type;
1283: l_norm_hours NUMBER;
1284: l_frequency per_all_assignments_f.frequency%type;
1285: l_employment_cat per_all_assignments_f.employment_category%type;
1286: l_person_number per_all_people_f.employee_number%type;
1287: l_act_typ_val pay_user_column_instances_f.value%type;
1288: l_act_typ_code VARCHAR2(10);

Line 1285: l_employment_cat per_all_assignments_f.employment_category%type;

1281: l_detache HR_SOFT_CODING_KEYFLEX.segment14%type;
1282: l_act_type per_contracts_f.type%type;
1283: l_norm_hours NUMBER;
1284: l_frequency per_all_assignments_f.frequency%type;
1285: l_employment_cat per_all_assignments_f.employment_category%type;
1286: l_person_number per_all_people_f.employee_number%type;
1287: l_act_typ_val pay_user_column_instances_f.value%type;
1288: l_act_typ_code VARCHAR2(10);
1289: l_pension_info pay_element_entries_f.entry_information1%type;

Line 1303: l_assignment_id per_all_assignments_f.assignment_id%type;

1299: l_prof_expense_lump_sums_sign VARCHAR2(1);
1300: l_actual_prof_expenses_sign VARCHAR2(1);
1301: l_prof_exp_pd_by_comp_sign VARCHAR2(1);
1302: l_reimb_nprof_exp_sign VARCHAR2(1);
1303: l_assignment_id per_all_assignments_f.assignment_id%type;
1304: l_id2 VARCHAR2(30);
1305:
1306: --Used in determining reason code 21....
1307: l_21_con_old Varchar2(250); --contract category-- proration is feasible

Line 1549: from per_all_assignments_f

1545: --Get the last but one date for getting the values
1546: BEGIN
1547: select max(effective_start_date)
1548: into l_param_start_date
1549: from per_all_assignments_f
1550: where assignment_id = p_assignment_id
1551: and effective_start_date < g_param_start_date;
1552: IF l_param_start_date IS NULL THEN
1553: l_param_start_date := g_param_start_date;