APPS.PAY_NO_EOY_ARCHIVE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 616: l_classification pay_element_classifications.classification_name%TYPE;

612: FUNCTION is_EA_classification (l_element_type_id IN NUMBER
613: ,l_report_date IN DATE)
614: RETURN BOOLEAN AS
615: --
616: l_classification pay_element_classifications.classification_name%TYPE;
617: --
618: BEGIN
619: --
620: SELECT pec.classification_name

Line 622: FROM pay_element_classifications pec

618: BEGIN
619: --
620: SELECT pec.classification_name
621: INTO l_classification
622: FROM pay_element_classifications pec
623: ,pay_element_types_f pet
624: WHERE pet.element_type_id = l_element_type_id
625: AND pec.classification_id = pet.classification_id
626: AND l_report_date BETWEEN pet.effective_start_date

Line 2255: FROM pay_element_classifications

2251: AND cde_dtl.action_information7 = 'PROCEDURE';
2252: --
2253: CURSOR csr_Seaman IS
2254: SELECT classification_id
2255: FROM pay_element_classifications
2256: WHERE classification_name = 'Seaman _ Earnings';
2257: --
2258: CURSOR csr_Seaman_Status
2259: (l_element_type IN NUMBER

Line 2438: l_classification_id pay_element_classifications.classification_id%TYPE;

2434: l_act_inf_id NUMBER;
2435: l_ovn NUMBER;
2436: l_amount NUMBER;
2437: l_rr_id NUMBER := -1;
2438: l_classification_id pay_element_classifications.classification_id%TYPE;
2439: l_element_type_id pay_element_Types_f.element_type_id%TYPE;
2440: l_element_name pay_element_types_f.element_name%TYPE;
2441: rec_613_616_details csr_613_616_details%ROWTYPE;
2442: l_seaman_status VARCHAR2(2);