APPS.PSP_ENC_CREATE_LINES dependencies on PAY_ELEMENT_TYPES_F

Line 850: pay_element_types_f pet,

846: FROM pay_element_entry_values_f peev,
847: pay_input_values_f piv,
848: pay_element_entries_f pee,
849: pay_element_links_f pel,
850: pay_element_types_f pet,
851: psp_enc_elements peel,
852: per_assignments_f paf,
853: per_assignment_status_types past,
854: per_time_periods ptp

Line 955: pay_element_types_f pet,

951: FROM pay_element_entry_values_f peev,
952: pay_input_values_f piv,
953: pay_element_entries_f pee,
954: pay_element_links_f pel,
955: pay_element_types_f pet,
956: psp_enc_elements peel,
957: per_assignments_f paf,
958: per_assignment_status_types past
959: WHERE peev.element_entry_id = pee.element_entry_id

Line 6806: l_element_name pay_element_types_f.element_name%TYPE;

6802: l_max_asg_id NUMBER(15);
6803: l_enc_period_end_date DATE;
6804: l_enc_period_date DATE;
6805: l_element_type_id NUMBER;
6806: l_element_name pay_element_types_f.element_name%TYPE;
6807: l_return_status VARCHAR2(1);
6808: l_enc_org_end_date DATE;
6809: l_max_enc_date DATE;
6810: l_enc_create NUMBER;

Line 6869: PAY_ELEMENT_TYPES_F pet,

6865: pet.element_type_id,
6866: pc.costing_debit_or_credit
6867: FROM PAY_ELEMENT_ENTRIES_F pee,
6868: PAY_ELEMENT_LINKS_F pel,
6869: PAY_ELEMENT_TYPES_F pet,
6870: PER_ASSIGNMENTS_F pa,
6871: PAY_ELEMENT_CLASSIFICATIONS pc
6872: WHERE pee.assignment_id = p_assignment_id
6873: AND pa.assignment_id = p_assignment_id

Line 6984: FROM pay_element_types_f

6980: WHERE organization_id = l_organization_id;
6981:
6982: CURSOR element_name_cur IS
6983: SELECT element_name
6984: FROM pay_element_types_f
6985: WHERE element_type_id = l_element_type_id
6986: AND ROWNUM = 1;
6987:
6988: CURSOR emphours_config_cur IS