APPS.PAY_FR_DADS_EMP_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 741: from pay_element_entries_f pee

737: || ' 00:00:00', 'dd-mm-yyyy hh24:mi:ss')
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

Line 1029: From pay_element_entries_f pef

1025: -- Cursor to fetch the pension information....
1026: --
1027: Cursor fetch_pension_info(p_date Date) Is
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

Line 1106: From pay_element_entries_f pef

1102:
1103: --Cursor for multiple employer
1104: Cursor get_multi_emp(p_effective_date DATE) Is
1105: Select pef.element_entry_id element_entry_id
1106: From pay_element_entries_f pef
1107: ,pay_element_links_f pel
1108: ,pay_element_types_f pet
1109: Where pef.assignment_id = p_assignment_id
1110: And pef.element_link_id = pel.element_link_id

Line 1276: l_element_entry_id pay_element_entries_f.element_entry_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;
1280: l_border_worker HR_SOFT_CODING_KEYFLEX.segment12%type;

Line 1289: l_pension_info pay_element_entries_f.entry_information1%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;
1290: l_pen_agirc_val pay_user_column_instances_f.value%type;
1291: l_emp_cat_code VARCHAR2(10);
1292: l_col_aggr_code VARCHAR2(4);
1293: l_pension_code NUMBER;