APPS.PAY_US_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 605: pay_balance_types pbt

601: select pbt.balance_name,pdb.defined_balance_id,fue.user_entity_name
602: from ff_user_entities fue,
603: pay_defined_balances pdb,
604: pay_balance_dimensions pbd,
605: pay_balance_types pbt
606: where pbt.balance_name in (
607: 'Territory Pension Annuity',
608: 'Territory Reimb Expenses',
609: 'Territory Taxable Comm',

Line 784: select 'Y' from pay_balance_types pbt

780: where hoi.organization_id = cp_tax_unit_id
781: and hoi.org_information_context = '1099R Magnetic Report Rules';
782:
783: cursor c_balance_feed_info(cp_balance_name in varchar2) is
784: select 'Y' from pay_balance_types pbt
785: where pbt.balance_name = cp_balance_name
786: and((pbt.legislation_code = 'US' and
787: pbt.business_group_id is null)
788: or(pbt.legislation_code is null and

Line 804: pay_balance_types pbt

800: select pbt.balance_name,pdb.defined_balance_id,fue.user_entity_name
801: from ff_user_entities fue,
802: pay_defined_balances pdb,
803: pay_balance_dimensions pbd,
804: pay_balance_types pbt
805: where pbt.balance_name in (
806: 'Capital Gain',
807: 'EE Contributions Or Premiums',
808: 'Other EE Annuity Contract Amt',

Line 1041: pay_balance_types pbt

1037: select pdb.defined_balance_id,fue.user_entity_name
1038: from ff_user_entities fue,
1039: pay_defined_balances pdb,
1040: pay_balance_dimensions pbd,
1041: pay_balance_types pbt
1042: where pbt.balance_name = cp_balance_name
1043: and pbd.database_item_suffix= cp_balance_dimension
1044: and pbt.balance_type_id = pdb.balance_type_id
1045: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1186: from pay_balance_types pbt,

1182:
1183: cursor c_get_psd_balance
1184: is
1185: select substr(flv.meaning, 1 , (instr(flv.meaning, 'YTD')-2)) --pbt.balance_type_id
1186: from pay_balance_types pbt,
1187: fnd_application fa,
1188: fnd_lookup_values flv,
1189: fnd_lookup_types flt
1190: where pbt.legislation_code = 'US'

Line 3618: lv_balance_name pay_balance_types.balance_name%type;

3614: l_psd_def_bal_id pay_defined_balances.defined_balance_id%type;
3615: l_psd_user_entity_id ff_user_entities.user_entity_id%type;
3616: lv_user_entity_name ff_user_entities.user_entity_name%type;
3617: ln_business_group_id number;
3618: lv_balance_name pay_balance_types.balance_name%type;
3619: ln_psd_def_bal_id pay_defined_balances.defined_balance_id%type;
3620: ln_bal_value number;
3621:
3622: