DBA Data[Home] [Help]

APPS.PAY_FR_RUN_TYPES dependencies on PAY_RUN_TYPES

Line 88: ,pay_run_types_f rt

84: ,etu.object_version_number
85: ,etu.business_group_id
86: ,etu.legislation_code
87: From pay_element_type_usages_f etu
88: ,pay_run_types_f rt
89: Where rt.legislation_code = 'FR'
90: And rt.shortname = c_run_type
91: And etu.run_type_id = rt.run_type_id
92: And etu.element_type_id = p_element_type_id;

Line 106: From pay_run_types_f

102: Is
103:
104: Cursor csr_run_type_id Is
105: Select run_type_id
106: From pay_run_types_f
107: Where shortname = p_run_type
108: and legislation_code = p_legislation_code;
109:
110: l_run_type_id pay_run_types.run_type_id%TYPE;

Line 110: l_run_type_id pay_run_types.run_type_id%TYPE;

106: From pay_run_types_f
107: Where shortname = p_run_type
108: and legislation_code = p_legislation_code;
109:
110: l_run_type_id pay_run_types.run_type_id%TYPE;
111:
112: Begin
113:
114: Open csr_run_type_id ;

Line 428: ,pay_run_types_f rt

424: ,etu.object_version_number
425: ,etu.business_group_id
426: ,etu.legislation_code
427: From pay_element_type_usages_f etu
428: ,pay_run_types_f rt
429: Where rt.legislation_code = 'FR'
430: And rt.shortname In ('STANDARD', 'NET', 'SICKNESS')
431: And etu.run_type_id = rt.run_type_id;
432: