APPS.PSP_ENC_CREATE_LINES dependencies on PAY_ELEMENT_TYPES_F

Line 648: pay_element_types_f pet,

644: FROM pay_element_entry_values_f peev,
645: pay_input_values_f piv,
646: pay_element_entries_f pee,
647: pay_element_links_f pel,
648: pay_element_types_f pet,
649: psp_enc_elements peel,
650: per_assignments_f paf,
651: per_assignment_status_types past,
652: per_time_periods ptp

Line 753: pay_element_types_f pet,

749: FROM pay_element_entry_values_f peev,
750: pay_input_values_f piv,
751: pay_element_entries_f pee,
752: pay_element_links_f pel,
753: pay_element_types_f pet,
754: psp_enc_elements peel,
755: per_assignments_f paf,
756: per_assignment_status_types past
757: WHERE peev.element_entry_id = pee.element_entry_id

Line 6549: l_element_name pay_element_types_f.element_name%TYPE;

6545: l_max_asg_id NUMBER(15);
6546: l_enc_period_end_date DATE;
6547: l_enc_period_date DATE;
6548: l_element_type_id NUMBER;
6549: l_element_name pay_element_types_f.element_name%TYPE;
6550: l_return_status VARCHAR2(1);
6551: l_enc_org_end_date DATE;
6552: l_max_enc_date DATE;
6553: l_enc_create NUMBER;

Line 6603: PAY_ELEMENT_TYPES_F pet,

6599: pet.element_type_id,
6600: pc.costing_debit_or_credit
6601: FROM PAY_ELEMENT_ENTRIES_F pee,
6602: PAY_ELEMENT_LINKS_F pel,
6603: PAY_ELEMENT_TYPES_F pet,
6604: PER_ASSIGNMENTS_F pa,
6605: PAY_ELEMENT_CLASSIFICATIONS pc
6606: WHERE pee.assignment_id = p_assignment_id
6607: AND pa.assignment_id = p_assignment_id

Line 6707: FROM pay_element_types_f

6703: WHERE organization_id = l_organization_id;
6704:
6705: CURSOR element_name_cur IS
6706: SELECT element_name
6707: FROM pay_element_types_f
6708: WHERE element_type_id = l_element_type_id
6709: AND ROWNUM = 1;
6710:
6711: CURSOR emphours_config_cur IS