DBA Data[Home] [Help]

APPS.PAY_BEE_UPGRADE_PKG dependencies on PER_BUSINESS_GROUPS

Line 139: g_business_group_id per_business_groups.business_group_id%TYPE := NULL;

135: g_input_values input_value_tbl_rec;
136: g_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
137: g_element_name pay_element_types_f.element_name%TYPE := NULL;
138: g_effective_date pay_batch_lines.effective_date%TYPE := NULL;
139: g_business_group_id per_business_groups.business_group_id%TYPE := NULL;
140: g_legislation_code per_business_groups.legislation_code%TYPE := NULL;
141: --
142: type input_value_rec is record(
143: element_type_id pay_element_types_f.element_type_id%TYPE,

Line 140: g_legislation_code per_business_groups.legislation_code%TYPE := NULL;

136: g_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
137: g_element_name pay_element_types_f.element_name%TYPE := NULL;
138: g_effective_date pay_batch_lines.effective_date%TYPE := NULL;
139: g_business_group_id per_business_groups.business_group_id%TYPE := NULL;
140: g_legislation_code per_business_groups.legislation_code%TYPE := NULL;
141: --
142: type input_value_rec is record(
143: element_type_id pay_element_types_f.element_type_id%TYPE,
144: element_name pay_element_types_f.element_name%TYPE,

Line 720: per_business_groups pbg

716: pbg.legislation_code,
717: cact.payroll_action_id
718: from pay_temp_object_actions cact,
719: pay_payroll_actions pct,
720: per_business_groups pbg
721: where cact.object_id = P_ASG_ID
722: and pct.payroll_action_id = cact.payroll_action_id
723: and pbg.business_group_id = pct.business_group_id;
724: --

Line 729: L_LEG_CODE per_business_groups.legislation_code%TYPE := NULL;

725: l_chunk_number pay_temp_object_actions.chunk_number%TYPE;
726: --
727: L_ASG_ID per_all_assignments_f.assignment_id%TYPE := P_ASG_ID;
728: L_BG_ID per_all_assignments_f.business_group_id%TYPE NULL;
729: L_LEG_CODE per_business_groups.legislation_code%TYPE := NULL;
730: L_PCT_ID pay_payroll_actions.payroll_action_id%TYPE := NULL;
731: --
732: cursor csr_max_chunck_num (p_pct_id number) is
733: select max(cact.chunk_number) last_chunk