APPS.PAY_NO_EOY_ARCHIVE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 523: l_classification pay_element_classifications.classification_name%TYPE;

519: FUNCTION is_EA_classification (l_element_type_id IN NUMBER
520: ,l_report_date IN DATE)
521: RETURN BOOLEAN AS
522: --
523: l_classification pay_element_classifications.classification_name%TYPE;
524: --
525: BEGIN
526: --
527: SELECT pec.classification_name

Line 529: FROM pay_element_classifications pec

525: BEGIN
526: --
527: SELECT pec.classification_name
528: INTO l_classification
529: FROM pay_element_classifications pec
530: ,pay_element_types_f pet
531: WHERE pet.element_type_id = l_element_type_id
532: AND pec.classification_id = pet.classification_id
533: AND l_report_date BETWEEN pet.effective_start_date

Line 2011: FROM pay_element_classifications

2007: AND cde_dtl.action_information7 = 'PROCEDURE';
2008: --
2009: CURSOR csr_Seaman IS
2010: SELECT classification_id
2011: FROM pay_element_classifications
2012: WHERE classification_name = 'Seaman _ Earnings';
2013: --
2014: CURSOR csr_Seaman_Status
2015: (l_element_type IN NUMBER

Line 2179: l_classification_id pay_element_classifications.classification_id%TYPE;

2175: l_act_inf_id NUMBER;
2176: l_ovn NUMBER;
2177: l_amount NUMBER;
2178: l_rr_id NUMBER := -1;
2179: l_classification_id pay_element_classifications.classification_id%TYPE;
2180: l_element_type_id pay_element_Types_f.element_type_id%TYPE;
2181: l_element_name pay_element_types_f.element_name%TYPE;
2182: rec_613_616_details csr_613_616_details%ROWTYPE;
2183: l_seaman_status VARCHAR2(2);