APPS.PAY_RETRO_STATUS_INTERNAL dependencies on PAY_RETRO_COMPONENTS

Line 99: from pay_retro_components

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

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

965: -- -------------------------------------------------------------------------
966: -- {Start Of Comments}
967: --
968: -- Description:
969: -- Validates that the retro component id exists in pay_retro_components.
970: --
971: -- Prerequisites:
972: -- None.
973: --

Line 1005: from pay_retro_components

1001: -- Cursor to check that a retro component exists.
1002: --
1003: cursor csr_retro_component is
1004: select 1
1005: from pay_retro_components
1006: where retro_component_id = p_retro_component_id
1007: and nvl(legislation_code, l_legislation_code) = l_legislation_code
1008: ;
1009: --

Line 1074: l_component_name pay_retro_components.component_name%type;

1070: )
1071: is
1072: l_dummy number;
1073: l_element_name pay_element_types_f_tl.element_name%type;
1074: l_component_name pay_retro_components.component_name%type;
1075: --
1076: cursor csr_rcu
1077: is
1078: select 1

Line 1910: l_component_name pay_retro_components.component_name%type;

1906: l_element_type_id number;
1907: l_element_name pay_element_types_f_tl.element_name%type;
1908: l_business_group_id number;
1909: l_legislation_code per_business_groups.legislation_code%type;
1910: l_component_name pay_retro_components.component_name%type;
1911: l_payroll_id number;
1912: l_retro_component_id number;
1913: l_reprocess_date date;
1914: l_system_reprocess_date date;