DBA Data[Home] [Help]

APPS.PAY_US_USER_INIT_DEDN dependencies on PAY_BALANCE_TYPES

Line 336: from pay_balance_types

332: l_bal_id number := null ;
333: l_proc varchar2(200);
334: cursor c_bal is
335: select balance_type_id
336: from pay_balance_types
337: where balance_name = p_jd_bal_name
338: and legislation_code = 'US';
339: begin
340: l_proc := g_proc||'.get_template_id';

Line 536: , PAY_BALANCE_TYPES BT

532: ,bf.scale
533: ,et.element_type_id
534: from pay_balance_classifications bc
535: , PAY_BALANCE_FEEDS_F BF
536: , PAY_BALANCE_TYPES BT
537: , PAY_INPUT_VALUES_F IV
538: , PAY_ELEMENT_TYPES_F ET
539: , PAY_ELEMENT_CLASSIFICATIONS EC
540: , HR_LOOKUPS HL

Line 567: from pay_balance_types

563:
564: -- To get the balance type id
565: cursor c2_balance_type is
566: select balance_type_id
567: from pay_balance_types
568: where business_group_id = p_bg_id
569: and balance_name in (p_ele_name||' Eligible Comp',
570: p_ele_name||' Roth Eligible Comp',
571: p_ele_name||' AT Eligible Comp');