DBA Data[Home] [Help]

APPS.PAY_BALANCE_FEED_DEL_PKG dependencies on PAY_BALANCE_TYPES

Line 45: pay_balance_types bt

41: from pay_sub_classification_rules_f scr,
42: pay_input_values_f iv,
43: pay_balance_feeds_f bf,
44: pay_balance_classifications bc,
45: pay_balance_types bt
46: where scr.sub_classification_rule_id = p_sub_classification_rule_id
47: and iv.element_type_id = scr.element_type_id
48: and iv.name = p_pay_value_name
49: and bc.classification_id = scr.classification_id

Line 65: bal_type_id pay_balance_types.balance_type_id%type;

61: g_val_end_date date default hr_general.end_of_time;
62: g_dt_mode varchar2(10) default 'ZAP';
63:
64: bal_rowid rowid;
65: bal_type_id pay_balance_types.balance_type_id%type;
66: inp_value_id pay_input_values_f.input_value_id%type;
67: eff_start_date Date;
68: sub_rowid rowid;
69: