DBA Data[Home] [Help]

APPS.PAY_FR_DADS_EMP_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 691: ,hr_soft_coding_keyflex scl

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

Line 716: ,hr_soft_coding_keyflex scl

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

Line 1004: , HR_SOFT_CODING_KEYFLEX sck

1000: ,pay_assignment_actions paa
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

Line 1279: l_prof_code HR_SOFT_CODING_KEYFLEX.segment16%type;

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;
1281: l_detache HR_SOFT_CODING_KEYFLEX.segment14%type;
1282: l_act_type per_contracts_f.type%type;
1283: l_norm_hours NUMBER;

Line 1280: l_border_worker HR_SOFT_CODING_KEYFLEX.segment12%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;
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;

Line 1281: l_detache HR_SOFT_CODING_KEYFLEX.segment14%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;
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;