APPS.HRASSACT dependencies on PAY_BALANCE_FEEDS_F

Line 2952: pay_balance_feeds_f pbf,

2948: select
2949: plb.latest_balance_id
2950: from
2951: pay_input_values_f piv,
2952: pay_balance_feeds_f pbf,
2953: pay_defined_balances pdb,
2954: pay_person_latest_balances plb,
2955: pay_assignment_actions paa,
2956: pay_payroll_actions ppa

Line 2977: pay_balance_feeds_f pbf,

2973: from pay_assignment_latest_balances alb,
2974: pay_assignment_actions act,
2975: pay_payroll_actions pac,
2976: pay_defined_balances pdb,
2977: pay_balance_feeds_f pbf,
2978: pay_input_values_f piv
2979: where act.assignment_id = alb.assignment_id
2980: and alb.assignment_id in
2981: (select distinct asg.assignment_id

Line 3002: pay_balance_feeds_f pbf,

2998: select
2999: plb.latest_balance_id
3000: from
3001: pay_input_values_f piv,
3002: pay_balance_feeds_f pbf,
3003: pay_defined_balances pdb,
3004: pay_latest_balances plb,
3005: pay_assignment_actions paa,
3006: pay_payroll_actions ppa

Line 7061: pay_balance_feeds_f pbf

7057: pdb.balance_type_id,
7058: pbf.scale
7059: from pay_latest_balances plb,
7060: pay_defined_balances pdb,
7061: pay_balance_feeds_f pbf
7062: where pbf.input_value_id = p_inp_val_id
7063: and effdate between pbf.effective_start_date
7064: and pbf.effective_end_date
7065: and pdb.balance_type_id = pbf.balance_type_id

Line 7078: -- ie pay_balance feeds_f (subject to feed checking)

7074: or plb.process_group_id is null);
7075:
7076: --
7077: -- cursor to get the assignment latest balances that may be fed
7078: -- ie pay_balance feeds_f (subject to feed checking)
7079: --
7080: cursor fed_assignment_balances(p_inp_val_id number,
7081: p_asgid number) is
7082: select palb.latest_balance_id,

Line 7094: pay_balance_feeds_f pbf

7090: pdb.balance_type_id,
7091: pbf.scale
7092: from pay_assignment_latest_balances palb,
7093: pay_defined_balances pdb,
7094: pay_balance_feeds_f pbf
7095: where pbf.input_value_id = p_inp_val_id
7096: and effdate between pbf.effective_start_date
7097: and pbf.effective_end_date
7098: and pdb.balance_type_id = pbf.balance_type_id

Line 7103: -- ie pay_balance feeds_f (subject to feed checking)

7099: and palb.defined_balance_id = pdb.defined_balance_id
7100: and palb.assignment_id = p_asgid;
7101: --
7102: -- cursor to get the person latest balances that may be fed
7103: -- ie pay_balance feeds_f (subject to feed checking)
7104: --
7105: cursor fed_person_balances(p_inp_val_id number,
7106: p_person_id number) is
7107: select pplb.latest_balance_id,

Line 7119: pay_balance_feeds_f pbf

7115: pdb.balance_type_id,
7116: pbf.scale
7117: from pay_person_latest_balances pplb,
7118: pay_defined_balances pdb,
7119: pay_balance_feeds_f pbf
7120: where pbf.input_value_id = p_inp_val_id
7121: and effdate between pbf.effective_start_date
7122: and pbf.effective_end_date
7123: and pdb.balance_type_id = pbf.balance_type_id