DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY dependencies on HR_ASSIGNMENT_SETS

Line 1137: hr_assignment_sets has

1133: is
1134: select distinct hasa.include_or_exclude inc_or_exc
1135: from
1136: hr_assignment_set_amendments hasa,
1137: hr_assignment_sets has
1138: where hasa.assignment_set_id = has.assignment_set_id
1139: and has.business_group_id = g_business_group_id
1140: and has.assignment_set_id = v_assignment_set_id;
1141:

Line 1858: select PAYROLL_ID into v_payroll_id from HR_ASSIGNMENT_SETS where ASSIGNMENT_SET_ID=v_assignment_set_id;

1854: /* To handle the assignment set with no Assignments included or excluded */
1855: v_count := 2;
1856: END IF;
1857:
1858: select PAYROLL_ID into v_payroll_id from HR_ASSIGNMENT_SETS where ASSIGNMENT_SET_ID=v_assignment_set_id;
1859:
1860: IF range_person_on
1861: THEN
1862: