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 HR_ORGANIZATION_INFORMATION

Line 5: g_param_company_id hr_organization_information.organization_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;
9: g_param_business_group_id hr_organization_information.organization_id%type;

Line 6: g_param_estab_id hr_organization_information.organization_id%type;

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;
9: g_param_business_group_id hr_organization_information.organization_id%type;
10: g_param_reference VARCHAR2(100);

Line 9: g_param_business_group_id hr_organization_information.organization_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;
9: g_param_business_group_id hr_organization_information.organization_id%type;
10: g_param_reference VARCHAR2(100);
11: g_param_start_date Date;
12:
13: ----------------------------------

Line 83: , hr_organization_information org_est

79: , fnd_territories ft
80: , fnd_territories_tl ft_tl
81: , fnd_territories ft1
82: , fnd_territories_tl ft1_tl
83: , hr_organization_information org_est
84: , per_periods_of_service pps
85: Where paa.assignment_action_id = g_assign_action_id
86: And paf.assignment_id = paa.assignment_id
87: And paf.establishment_id = org_est.organization_id

Line 692: ,hr_organization_information org_est

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
694: and asg.effective_end_date >= g_param_start_date
695: and asg.effective_start_date <= g_effective_date
696: and asg.assignment_id = paa.assignment_id

Line 717: ,hr_organization_information org_est

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
719: and asg.effective_start_date >= c_param_start_date
720: and asg.effective_start_date <= c_end_date
721: and asg.assignment_id = paa.assignment_id

Line 743: ,hr_organization_information org_est

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
747: and asg.assignment_id = paa.assignment_id

Line 793: ,hr_organization_information org_est

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
796: and asg.person_id = p_person_id
797: and asg.assignment_id = paa.assignment_id

Line 818: ,hr_organization_information org_est

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
822: and asg.assignment_id = paa.assignment_id

Line 840: ,hr_organization_information org_est

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
844: and asg.effective_end_date >= g_param_start_date-1

Line 854: ,hr_organization_information org_est

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
858: and asg.effective_end_date >= g_param_start_date

Line 873: ,hr_organization_information org_est

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
877: And asg.effective_start_date >= g_param_start_date

Line 903: ,hr_organization_information org_est

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
906: ,hr_locations_all_tl hloc_asg_estab_tl
907: -- Getting the Establishment Name

Line 947: ,hr_organization_information org_est

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
951: ,hr_all_organization_units asg_estab_tl

Line 1005: , hr_organization_information org_est

1001: , per_jobs pj
1002: , per_all_people_f paf
1003: , per_contracts_f pc
1004: , HR_SOFT_CODING_KEYFLEX sck
1005: , hr_organization_information org_est
1006: , per_collective_agreements pca
1007: Where paa.assignment_action_id = g_assign_action_id
1008: and asg.person_id = paf.person_id
1009: And asg.person_id = p_person_id

Line 1033: , hr_organization_information org_est

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
1037: and paa.assignment_id = asg.assignment_id

Line 1078: ,hr_organization_information org_est

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
1082: And pps.person_id = asg.person_id

Line 1231: l_work_hr_org hr_organization_information.org_information3%type;

1227: l_professional_expenses_sign VARCHAR2(1);
1228: l_taxable_income_sign VARCHAR2(1);
1229:
1230:
1231: l_work_hr_org hr_organization_information.org_information3%type;
1232: l_work_risk_code hr_organization_information.org_information4%type;
1233: l_temp_work_risk_code hr_organization_information.org_information4%type;
1234: l_work_order_number hr_organization_information.org_information5%type;
1235: l_work_section_code hr_organization_information.org_information6%type;

Line 1232: l_work_risk_code hr_organization_information.org_information4%type;

1228: l_taxable_income_sign VARCHAR2(1);
1229:
1230:
1231: l_work_hr_org hr_organization_information.org_information3%type;
1232: l_work_risk_code hr_organization_information.org_information4%type;
1233: l_temp_work_risk_code hr_organization_information.org_information4%type;
1234: l_work_order_number hr_organization_information.org_information5%type;
1235: l_work_section_code hr_organization_information.org_information6%type;
1236: l_work_office_code hr_organization_information.org_information7%type;

Line 1233: l_temp_work_risk_code hr_organization_information.org_information4%type;

1229:
1230:
1231: l_work_hr_org hr_organization_information.org_information3%type;
1232: l_work_risk_code hr_organization_information.org_information4%type;
1233: l_temp_work_risk_code hr_organization_information.org_information4%type;
1234: l_work_order_number hr_organization_information.org_information5%type;
1235: l_work_section_code hr_organization_information.org_information6%type;
1236: l_work_office_code hr_organization_information.org_information7%type;
1237:

Line 1234: l_work_order_number hr_organization_information.org_information5%type;

1230:
1231: l_work_hr_org hr_organization_information.org_information3%type;
1232: l_work_risk_code hr_organization_information.org_information4%type;
1233: l_temp_work_risk_code hr_organization_information.org_information4%type;
1234: l_work_order_number hr_organization_information.org_information5%type;
1235: l_work_section_code hr_organization_information.org_information6%type;
1236: l_work_office_code hr_organization_information.org_information7%type;
1237:
1238: l_param_start_date DATE;

Line 1235: l_work_section_code hr_organization_information.org_information6%type;

1231: l_work_hr_org hr_organization_information.org_information3%type;
1232: l_work_risk_code hr_organization_information.org_information4%type;
1233: l_temp_work_risk_code hr_organization_information.org_information4%type;
1234: l_work_order_number hr_organization_information.org_information5%type;
1235: l_work_section_code hr_organization_information.org_information6%type;
1236: l_work_office_code hr_organization_information.org_information7%type;
1237:
1238: l_param_start_date DATE;
1239: l_effective_date DATE;

Line 1236: l_work_office_code hr_organization_information.org_information7%type;

1232: l_work_risk_code hr_organization_information.org_information4%type;
1233: l_temp_work_risk_code hr_organization_information.org_information4%type;
1234: l_work_order_number hr_organization_information.org_information5%type;
1235: l_work_section_code hr_organization_information.org_information6%type;
1236: l_work_office_code hr_organization_information.org_information7%type;
1237:
1238: l_param_start_date DATE;
1239: l_effective_date DATE;
1240:

Line 1271: l_old_coy hr_organization_information.organization_id%type;

1267: l_unused_number NUMBER;
1268: l_first_row BOOLEAN;
1269: l_old_value VARCHAR2(250);
1270: l_old_value_1 VARCHAR2(250);
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;

Line 1272: l_old_est hr_organization_information.organization_id%type;

1268: l_first_row BOOLEAN;
1269: l_old_value VARCHAR2(250);
1270: l_old_value_1 VARCHAR2(250);
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;