APPS.PAY_IP_PAYROLL_ARCH dependencies on PAY_BALANCE_TYPES

Line 412: lv_balance_name pay_balance_types.balance_name%TYPE;

408: lv_error_message VARCHAR2(200);
409:
410: ln_step NUMBER;
411: lv_action_category pay_action_information.action_information_category%TYPE;
412: lv_balance_name pay_balance_types.balance_name%TYPE;
413: BEGIN
414:
415: lv_procedure_name := '.populate_elements';
416: lv_is_element_archived := 'N';

Line 796: lv_balance_name pay_balance_types.balance_type_id%TYPE;

792: st_cnt NUMBER;
793: end_cnt NUMBER;
794: lv_business_grp_id NUMBER;
795: lv_run_bal_status VARCHAR2(1);
796: lv_balance_name pay_balance_types.balance_type_id%TYPE;
797:
798: BEGIN
799: lv_action_info_category := 'IP DEDUCTIONS';
800: lv_is_element_archived := 'N';

Line 1072: FROM pay_balance_types

1068: CURSOR c_get_balance (cp_balance_name IN VARCHAR2
1069: ,cp_business_group_id IN VARCHAR2
1070: ,cp_legislation_code IN VARCHAR2) IS
1071: SELECT balance_type_id
1072: FROM pay_balance_types
1073: WHERE balance_name = cp_balance_name
1074: AND ((business_group_id = cp_business_group_id AND legislation_code IS NULL)
1075: OR (legislation_code = cp_legislation_code AND business_group_id IS NULL));
1076:

Line 1139: lv_balance_name pay_balance_types.balance_name%TYPE;

1135: ln_assignment_id NUMBER;
1136: lv_act_info_category pay_action_information.action_information_category%TYPE;
1137: ln_last_per_xfr_action_id NUMBER;
1138: cn_last_xfr_action_id NUMBER;
1139: lv_balance_name pay_balance_types.balance_name%TYPE;
1140:
1141: BEGIN
1142: lv_is_element_archived := 'N';
1143: lv_action_info_category := 'IP DEDUCTIONS';

Line 2702: pay_balance_types_tl pbtl

2698: FROM pay_bal_attribute_definitions pbad,
2699: pay_balance_attributes pba,
2700: pay_defined_balances pdb,
2701: pay_balance_dimensions pbd,
2702: pay_balance_types_tl pbtl
2703: WHERE pbad.attribute_name IN ('ONLINE_SOE_BALANCE_ATTRIBUTE','STATUTORY_BALANCE_ATTRIBUTE')
2704: AND pbad.legislation_code = gv_legislation_code
2705: AND pba.attribute_id = pbad.attribute_id
2706: AND pdb.defined_balance_id = pba.defined_balance_id

Line 2725: FROM pay_balance_types

2721: AND prt.legislation_code = gv_legislation_code;
2722:
2723: CURSOR c_balance_type_id IS
2724: SELECT balance_type_id
2725: FROM pay_balance_types
2726: WHERE legislation_code = gv_legislation_code
2727: AND balance_name = 'Total Payments';
2728:
2729: CURSOR c_get_legislation_code (cp_business_group IN NUMBER) IS