APPS.PAY_AE_ELEMENT_TEMPLATE_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 336: ,pay_element_classifications pec

332: ,cp_element_name VARCHAR2) IS
333: SELECT pet.element_type_id
334: FROM pay_element_types_f pet
335: ,pay_sub_classification_rules_f psc
336: ,pay_element_classifications pec
337: WHERE pet.business_group_id = cp_business_group_id
338: AND pet.element_name = cp_element_name
339: AND pet.element_type_id = psc.element_type_id
340: AND pet.business_group_id = psc.business_group_id

Line 358: FROM pay_element_classifications pec

354: rec_get_info_element_det csr_get_info_element_det%ROWTYPE;
355:
356: CURSOR csr_get_classification_id IS
357: SELECT classification_id
358: FROM pay_element_classifications pec
359: WHERE classification_name = 'Subject to Social Insurance : Information'
360: AND legislation_code = 'AE';
361:
362: l_base_name pay_element_types_f.element_name%TYPE;

Line 793: FROM pay_element_classifications

789: -------------------------------------------------------------------------
790: DECLARE
791: CURSOR csr_get_class_id IS
792: SELECT classification_id
793: FROM pay_element_classifications
794: WHERE legislation_code = 'AE'
795: AND classification_name = 'Earnings';
796: l_classification_id NUMBER;
797:

Line 1044: FROM pay_element_classifications

1040: -------------------------------------------------------------------------
1041: DECLARE
1042: CURSOR csr_get_class_id IS
1043: SELECT classification_id
1044: FROM pay_element_classifications
1045: WHERE legislation_code = 'AE'
1046: AND classification_name = 'Earnings';
1047: l_classification_id NUMBER;
1048:

Line 1297: FROM pay_element_classifications

1293: -------------------------------------------------------------------------
1294: DECLARE
1295: CURSOR csr_get_class_id IS
1296: SELECT classification_id
1297: FROM pay_element_classifications
1298: WHERE legislation_code = 'AE'
1299: AND classification_name = 'Earnings';
1300: l_classification_id NUMBER;
1301:

Line 1780: FROM pay_element_classifications

1776: -------------------------------------------------------------------------
1777: DECLARE
1778: CURSOR csr_get_class_id IS
1779: SELECT classification_id
1780: FROM pay_element_classifications
1781: WHERE legislation_code = 'AE'
1782: AND classification_name = 'Earnings';
1783: l_classification_id NUMBER;
1784:

Line 2169: FROM pay_element_classifications

2165: -------------------------------------------------------------------------
2166: DECLARE
2167: CURSOR csr_get_class_id IS
2168: SELECT classification_id
2169: FROM pay_element_classifications
2170: WHERE legislation_code = 'AE'
2171: AND classification_name = 'Earnings';
2172: l_classification_id NUMBER;
2173:

Line 2480: FROM pay_element_classifications

2476: -------------------------------------------------------------------------
2477: DECLARE
2478: CURSOR csr_get_class_id IS
2479: SELECT classification_id
2480: FROM pay_element_classifications
2481: WHERE legislation_code = 'AE'
2482: AND classification_name = 'Earnings';
2483: l_classification_id NUMBER;
2484:

Line 2789: FROM pay_element_classifications

2785: -------------------------------------------------------------------------
2786: DECLARE
2787: CURSOR csr_get_class_id IS
2788: SELECT classification_id
2789: FROM pay_element_classifications
2790: WHERE legislation_code = 'AE'
2791: AND classification_name = 'Earnings';
2792: l_classification_id NUMBER;
2793:

Line 3049: FROM pay_element_classifications

3045: -------------------------------------------------------------------------
3046: DECLARE
3047: CURSOR csr_get_class_id IS
3048: SELECT classification_id
3049: FROM pay_element_classifications
3050: WHERE legislation_code = 'AE'
3051: AND classification_name = 'Earnings';
3052: l_classification_id NUMBER;
3053:

Line 3371: FROM pay_element_classifications

3367: -------------------------------------------------------------------------
3368: DECLARE
3369: CURSOR csr_get_class_id IS
3370: SELECT classification_id
3371: FROM pay_element_classifications
3372: WHERE legislation_code = 'AE'
3373: AND classification_name = 'Earnings';
3374: l_classification_id NUMBER;
3375:

Line 3642: FROM pay_element_classifications

3638: -------------------------------------------------------------------------
3639: DECLARE
3640: CURSOR csr_get_class_id IS
3641: SELECT classification_id
3642: FROM pay_element_classifications
3643: WHERE legislation_code = 'AE'
3644: AND classification_name = 'Earnings';
3645: l_classification_id NUMBER;
3646:

Line 3995: FROM pay_element_classifications

3991: -------------------------------------------------------------------------
3992: DECLARE
3993: CURSOR csr_get_class_id IS
3994: SELECT classification_id
3995: FROM pay_element_classifications
3996: WHERE legislation_code = 'AE'
3997: AND classification_name = 'Earnings';
3998: l_classification_id NUMBER;
3999:

Line 4409: FROM pay_element_classifications

4405: -------------------------------------------------------------------------
4406: DECLARE
4407: CURSOR csr_get_class_id IS
4408: SELECT classification_id
4409: FROM pay_element_classifications
4410: WHERE legislation_code = 'AE'
4411: AND classification_name = 'Absence';
4412: l_classification_id NUMBER;
4413: