APPS.PAY_US_PSD_XML dependencies on PAY_DEFINED_BALANCES

Line 114: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

110: AND UE.user_entity_id = DI.user_entity_id
111: AND UE.creator_type = 'B'
112: AND UE.legislation_code = 'US';
113:
114: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
115: BEGIN
116: hr_utility.set_location
117: ('pay_us_psd_xml.bal_db_item - opening cursor', 10);
118: -- Open the cursor

Line 230: from pay_defined_balances pdb,

226: cp_business_group_id in number,
227: cp_balance_name in varchar2,
228: cp_balance_dimension in varchar2 ) is
229: select pdb.defined_balance_id
230: from pay_defined_balances pdb,
231: pay_balance_dimensions pbd,
232: pay_balance_types pbt
233: where pbt.balance_name = cp_balance_name
234: and pbd.database_item_suffix= cp_balance_dimension

Line 1522: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

1518: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1519:
1520: /* Variable holding the balance to be tested. */
1521:
1522: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
1523:
1524: /* Indicator variables used to control how the people are grouped. */
1525:
1526: l_group_by_gre boolean := FALSE;

Line 1530: l_psd_def_bal_id pay_defined_balances.defined_balance_id%type;

1526: l_group_by_gre boolean := FALSE;
1527:
1528: /* Local variables to select only those employees those PSD Withheld <>0*/
1529:
1530: l_psd_def_bal_id pay_defined_balances.defined_balance_id%type;
1531: l_psd_user_entity_id ff_database_items.user_entity_id%type;
1532: l_psd_balance_value number(15,2):=0;
1533: l_aaid pay_assignment_actions.assignment_action_id%type;
1534: l_eff_date date;

Line 2801: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

2797: l_chunk number;
2798: l_payroll_action_id number;
2799: l_context_no number := 60;
2800: l_count number := 0;
2801: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
2802: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
2803:
2804: /* Local variables to select only those employees those PSD Withheld <>0*/
2805:

Line 2806: l_psd_def_bal_id pay_defined_balances.defined_balance_id%type;

2802: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
2803:
2804: /* Local variables to select only those employees those PSD Withheld <>0*/
2805:
2806: l_psd_def_bal_id pay_defined_balances.defined_balance_id%type;
2807: l_psd_user_entity_id ff_database_items.user_entity_id%type;
2808: l_psd_balance_value number(15,2):=0;
2809:
2810: /* Local variables to archive PSD balances*/

Line 2814: ln_qtd_def_bal_id pay_defined_balances.defined_balance_id%type;

2810: /* Local variables to archive PSD balances*/
2811: lv_balance_name VARCHAR2(80);
2812: ln_balance_type_id pay_balance_types.balance_type_id%type;
2813: lv_balance_dimension VARCHAR2(80);
2814: ln_qtd_def_bal_id pay_defined_balances.defined_balance_id%type;
2815: ln_month_def_bal_id pay_defined_balances.defined_balance_id%type;
2816: ln_city_wk_def_bal_id pay_defined_balances.defined_balance_id%type;
2817: ln_psd_count NUMBER := 0;
2818: ln_bal_value NUMBER(15,2) := 0;

Line 2815: ln_month_def_bal_id pay_defined_balances.defined_balance_id%type;

2811: lv_balance_name VARCHAR2(80);
2812: ln_balance_type_id pay_balance_types.balance_type_id%type;
2813: lv_balance_dimension VARCHAR2(80);
2814: ln_qtd_def_bal_id pay_defined_balances.defined_balance_id%type;
2815: ln_month_def_bal_id pay_defined_balances.defined_balance_id%type;
2816: ln_city_wk_def_bal_id pay_defined_balances.defined_balance_id%type;
2817: ln_psd_count NUMBER := 0;
2818: ln_bal_value NUMBER(15,2) := 0;
2819:

Line 2816: ln_city_wk_def_bal_id pay_defined_balances.defined_balance_id%type;

2812: ln_balance_type_id pay_balance_types.balance_type_id%type;
2813: lv_balance_dimension VARCHAR2(80);
2814: ln_qtd_def_bal_id pay_defined_balances.defined_balance_id%type;
2815: ln_month_def_bal_id pay_defined_balances.defined_balance_id%type;
2816: ln_city_wk_def_bal_id pay_defined_balances.defined_balance_id%type;
2817: ln_psd_count NUMBER := 0;
2818: ln_bal_value NUMBER(15,2) := 0;
2819:
2820: l_user_entity_id ff_database_items.user_entity_id%type;