APPS.PAY_RETRO_STATUS_INTERNAL dependencies on PAY_RETRO_COMPONENTS

Line 100: from pay_retro_components

96: ) return varchar2
97: is
98: cursor csr_retro_component is
99: select component_name
100: from pay_retro_components
101: where retro_component_id = p_retro_component_id
102: ;
103: --
104: l_rec csr_retro_component%rowtype;

Line 937: -- Validates that the retro component id exists in pay_retro_components.

933: -- -------------------------------------------------------------------------
934: -- {Start Of Comments}
935: --
936: -- Description:
937: -- Validates that the retro component id exists in pay_retro_components.
938: --
939: -- Prerequisites:
940: -- None.
941: --

Line 973: from pay_retro_components

969: -- Cursor to check that a retro component exists.
970: --
971: cursor csr_retro_component is
972: select 1
973: from pay_retro_components
974: where retro_component_id = p_retro_component_id
975: and nvl(legislation_code, l_legislation_code) = l_legislation_code
976: ;
977: --

Line 1042: l_component_name pay_retro_components.component_name%type;

1038: )
1039: is
1040: l_dummy number;
1041: l_element_name pay_element_types_f_tl.element_name%type;
1042: l_component_name pay_retro_components.component_name%type;
1043: --
1044: cursor csr_rcu
1045: is
1046: select 1

Line 1955: l_component_name pay_retro_components.component_name%type;

1951: l_element_type_id number;
1952: l_element_name pay_element_types_f_tl.element_name%type;
1953: l_business_group_id number;
1954: l_legislation_code per_business_groups.legislation_code%type;
1955: l_component_name pay_retro_components.component_name%type;
1956: l_payroll_id number;
1957: l_retro_component_id number;
1958: l_reprocess_date date;
1959: l_system_reprocess_date date;