APPS.PER_RI_CRP_DEFAULT_SETTINGS dependencies on PAY_ELEMENT_TYPES_F

Line 77: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

73:
74: IS
75:
76: -- IN variables
77: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
78: l_effective_date DATE;
79: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE := 'N';
80: l_verify_element_link NUMBER;
81:

Line 93: FROM PAY_ELEMENT_TYPES_F

89:
90: -- Declare a cursor to capture the element type and effective start date
91: CURSOR csr_element IS
92: SELECT element_type_id,effective_start_date
93: FROM PAY_ELEMENT_TYPES_F
94: WHERE ELEMENT_NAME = p_element_name
95: AND LEGISLATION_CODE = p_legislation_code;
96:
97: BEGIN

Line 287: FROM PAY_INPUT_VALUES_F i,PAY_ELEMENT_TYPES_F e

283:
284: -- Declare a cursor to capture input value id
285: CURSOR csr_input_value_id IS
286: SELECT i.input_value_id
287: FROM PAY_INPUT_VALUES_F i,PAY_ELEMENT_TYPES_F e
288: WHERE i.element_type_id = e.element_type_id
289: AND i.name = p_input_value_name
290: AND e.element_name = p_element_name
291: AND e.legislation_code = p_legislation_code; -- CHANGE THE LEGISLATION CODE ACCORDING TO REQUIREMENT

Line 1001: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE := null;

997: l_bg_id NUMBER := null;
998: l_bg_start_date DATE := null;
999: l_bg_name PER_BUSINESS_GROUPS.NAME%TYPE := null;
1000: l_org_id NUMBER := null;
1001: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE := null;
1002: l_leg_code VARCHAR2(2) := null;
1003: l_short_code VARCHAR2(9) := null;
1004: --bugfix 4219436 vars
1005: l_crp_check_payment_method_id NUMBER := null;

Line 1033: FROM PAY_ELEMENT_TYPES_F

1029:
1030: -- Decalare a cursor to fetch the element name
1031: CURSOR csr_element_name(p_bg_id NUMBER) IS
1032: SELECT element_name
1033: FROM PAY_ELEMENT_TYPES_F
1034: WHERE business_group_id = p_bg_id
1035: AND indirect_only_flag = 'N'
1036: AND legislation_code is not null;
1037: