APPS.PAY_GB_MULTI_DML_AND_VAL dependencies on PAY_GB_PAYROLL_GROUPS

Line 18: INTO V_COUNT FROM PAY_GB_PAYROLL_GROUPS;

14: hr_utility.trace('V_COUNT:'||V_COUNT);
15:
16:
17: SELECT NVL(MAX(payroll_group_id),0)+1
18: INTO V_COUNT FROM PAY_GB_PAYROLL_GROUPS;
19:
20:
21: RETURN V_COUNT;
22: END GET_GROUP_MAX_ID;

Line 38: FROM PAY_GB_PAYROLL_GROUPS WHERE

34: P_FREQUENCY VARCHAR2(30);
35: BEGIN
36:
37: SELECT PAY_FREQUENCY INTO G_FREQUENCY
38: FROM PAY_GB_PAYROLL_GROUPS WHERE
39: PAYROLL_GROUP_ID =P_PAYROLL_GROUP_ID;
40:
41: SELECT distinct PERIOD_TYPE INTO P_FREQUENCY
42: FROM PAY_ALL_PAYROLLS_F WHERE

Line 91: FROM PAY_GB_PAYROLL_GROUPS PGPG

87: V_STATUS NUMBER :=0;
88: BEGIN
89:
90: SELECT PGPG.PAYROLL_GROUP_NAME INTO V_PAYROLL_GROUP_NAME
91: FROM PAY_GB_PAYROLL_GROUPS PGPG
92: WHERE PGPG.PAYROLL_GROUP_NAME=P_PAYROLL_GROUP_NAME
93: AND PGPG.BUSINESS_GROUP_ID=P_BUSINESS_GROUP_ID;
94:
95: V_STATUS:=0;

Line 214: INSERT INTO PAY_GB_PAYROLL_GROUPS

210:
211: IF VAL_PAYROLL_GROUPS(P_PAYROLL_GROUP_NAME,P_BUSINESS_GROUP_ID) =1 THEN
212:
213: hr_utility.trace(' VAL_PAYROLL_GROUPS returned 1');
214: INSERT INTO PAY_GB_PAYROLL_GROUPS
215: (
216: PAYROLL_GROUP_ID
217: ,PAYROLL_GROUP_NAME
218: ,PAY_FREQUENCY

Line 278: FROM PAY_GB_PAYROLL_GROUPS PGPG

274: AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
275: AND PAPF.BUSINESS_GROUP_ID=P_BUSINESS_GROUP_ID;
276:
277: SELECT PGPG.PAYROLL_GROUP_NAME INTO V_PAYROLL_GROUP_NAME
278: FROM PAY_GB_PAYROLL_GROUPS PGPG
279: WHERE PGPG.PAYROLL_GROUP_ID=P_PAYROLL_GROUP_ID
280: AND PGPG.BUSINESS_GROUP_ID=P_BUSINESS_GROUP_ID;
281:
282: hr_utility.trace('Payroll name is:'||V_PAYROLL_NAME);

Line 471: DELETE PAY_GB_PAYROLL_GROUPS PGPG

467: DELETE PAY_GB_PAYROLL_GROUP_MAPPINGS PGPGM
468: WHERE PGPGM.PAYROLL_GROUP_ID=P_PAYROLL_GROUP_ID
469: AND PGPGM.BUSINESS_GROUP_ID=P_BUSINESS_GROUP_ID;
470:
471: DELETE PAY_GB_PAYROLL_GROUPS PGPG
472: WHERE PGPG.PAYROLL_GROUP_ID=P_PAYROLL_GROUP_ID
473: AND PGPG.BUSINESS_GROUP_ID=P_BUSINESS_GROUP_ID;
474: COMMIT;
475: END DEL_PAYROLL_GROUP;