APPS.PAY_PAYWSDAS_PKG dependencies on HR_ASSIGNMENT_SETS

Line 161: select HR_ASSIGNMENT_SETS_S.nextval

157: --
158: function get_assignment_sets_s return number is
159: --
160: cursor C_ASS1 is
161: select HR_ASSIGNMENT_SETS_S.nextval
162: from DUAL;
163: --
164: ass_sets number(15);
165: --

Line 187: from HR_ASSIGNMENT_SETS

183: function get_formula_id(p_assignment_set_id in number) return number is
184: --
185: cursor C_FID2 is
186: select FORMULA_ID
187: from HR_ASSIGNMENT_SETS
188: where ASSIGNMENT_SET_ID = p_assignment_set_id;
189: --
190: formula_id HR_ASSIGNMENT_SETS.FORMULA_ID%type;
191: --

Line 190: formula_id HR_ASSIGNMENT_SETS.FORMULA_ID%type;

186: select FORMULA_ID
187: from HR_ASSIGNMENT_SETS
188: where ASSIGNMENT_SET_ID = p_assignment_set_id;
189: --
190: formula_id HR_ASSIGNMENT_SETS.FORMULA_ID%type;
191: --
192: begin
193: --
194: open C_FID2;

Line 419: from HR_ASSIGNMENT_SETS

415: p_legislation_code in varchar2) is
416: --
417: cursor C_CU1 is
418: select null
419: from HR_ASSIGNMENT_SETS
420: where upper(ASSIGNMENT_SET_NAME) = upper(p_assignment_set_name)
421: and business_group_id + 0 = p_business_group_id
422: and ( p_rowid is null
423: or

Line 539: from hr_assignment_sets a_s

535: select bg.business_group_id
536: , bg.legislation_code
537: into l_business_group_id
538: , l_legislation_code
539: from hr_assignment_sets a_s
540: , per_business_groups_perf bg
541: where a_s.assignment_set_id = p_assignment_set_id
542: and bg.business_group_id = a_s.business_group_id
543: ;