DBA Data[Home] [Help]

APPS.PAY_NO_K27_REIM_UPLD dependencies on HR_SOFT_CODING_KEYFLEX

Line 432: hr_soft_coding_keyflex hsck

428: IS
429: select distinct SEGMENT2
430: from
431: per_all_assignments_f paaf,
432: hr_soft_coding_keyflex hsck
433: where
434: paaf.assignment_id = p_asg_id
435: and paaf.business_group_id = p_business_group_id
436: and paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id

Line 439: l_asg_lu_id hr_soft_coding_keyflex.SEGMENT2%TYPE;

435: and paaf.business_group_id = p_business_group_id
436: and paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
437: AND p_date between paaf.EFFECTIVE_START_DATE and paaf.EFFECTIVE_END_DATE;
438:
439: l_asg_lu_id hr_soft_coding_keyflex.SEGMENT2%TYPE;
440:
441: CURSOR csr_lu_org_number
442: (p_business_group_id per_business_groups.business_group_id%TYPE,
443: p_asg_lu_org_id number)

Line 1070: hr_soft_coding_keyflex scl,

1066: pay_payrolls_f ppf,
1067: per_assignments_f paf,
1068: hr_organization_units hou,
1069: hr_organization_information hoi,
1070: hr_soft_coding_keyflex scl,
1071: per_time_periods ptp
1072: WHERE hou.business_group_id = l_business_group_id
1073: AND hou.organization_id = g_legal_employer_id
1074: AND hou.organization_id = hoi.organization_id