APPS.PER_RI_CRP_DEFAULT_SETTINGS dependencies on PAY_ELEMENT_LINKS_F

Line 79: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE := 'N';

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:
82: -- OUT variables
83: l_element_link_id PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID%TYPE;

Line 83: l_element_link_id PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID%TYPE;

79: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE := 'N';
80: l_verify_element_link NUMBER;
81:
82: -- OUT variables
83: l_element_link_id PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID%TYPE;
84: l_comment_id PAY_ELEMENT_LINKS_F.COMMENT_ID%TYPE;
85: l_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;
86: l_effective_start_date DATE;
87: l_effective_end_date DATE;

Line 84: l_comment_id PAY_ELEMENT_LINKS_F.COMMENT_ID%TYPE;

80: l_verify_element_link NUMBER;
81:
82: -- OUT variables
83: l_element_link_id PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID%TYPE;
84: l_comment_id PAY_ELEMENT_LINKS_F.COMMENT_ID%TYPE;
85: l_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;
86: l_effective_start_date DATE;
87: l_effective_end_date DATE;
88:

Line 85: l_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;

81:
82: -- OUT variables
83: l_element_link_id PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID%TYPE;
84: l_comment_id PAY_ELEMENT_LINKS_F.COMMENT_ID%TYPE;
85: l_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;
86: l_effective_start_date DATE;
87: l_effective_end_date DATE;
88:
89:

Line 106: FROM PAY_ELEMENT_LINKS_F

102: FETCH csr_element INTO l_element_type_id,l_effective_date;
103: CLOSE csr_element;
104:
105: SELECT COUNT(*) INTO l_verify_element_link
106: FROM PAY_ELEMENT_LINKS_F
107: WHERE element_type_id = l_element_type_id
108: AND business_group_id = p_bg_id
109: AND organization_id is null
110: AND people_group_id is null

Line 281: l_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE := null;

277: l_verify_salary_basis NUMBER;
278:
279: -- OUT Variables
280: l_pay_basis_id PER_PAY_BASES.PAY_BASIS_ID%TYPE := null;
281: l_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE := null;
282:
283:
284: -- Declare a cursor to capture input value id
285: CURSOR csr_input_value_id IS

Line 430: l_prl_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;

426:
427:
428: -- OUT Variables
429: l_org_pay_method_usage_id NUMBER;
430: l_prl_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;
431: l_opm_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;
432: l_prl_effective_start_date DATE;
433: l_prl_effective_end_date DATE;
434: l_opm_effective_start_date DATE;

Line 431: l_opm_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;

427:
428: -- OUT Variables
429: l_org_pay_method_usage_id NUMBER;
430: l_prl_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;
431: l_opm_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;
432: l_prl_effective_start_date DATE;
433: l_prl_effective_end_date DATE;
434: l_opm_effective_start_date DATE;
435: l_opm_effective_end_date DATE;

Line 637: l_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;

633:
634: -- OUT Variables
635: l_effective_start_date DATE;
636: l_effective_end_date DATE;
637: l_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;
638: l_asset_code_combination_id NUMBER;
639: l_comment_id NUMBER;
640: l_external_account_id NUMBER := null;
641:

Line 903: l_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;

899: l_verify_org_info NUMBER;
900:
901: -- OUT Variables
902: l_org_information_id HR_ORGANIZATION_INFORMATION.ORG_INFORMATION_ID%TYPE;
903: l_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;
904:
905:
906:
907: