APPS.PAY_BALANCE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 3545: , per_all_assignments_f ASSIGN

3541: PERBAL.expired_value,
3542: PERBAL.prev_assignment_action_id,
3543: PERBAL.prev_balance_value
3544: from pay_person_latest_balances PERBAL
3545: , per_all_assignments_f ASSIGN
3546: , pay_assignment_actions ACT
3547: , pay_payroll_actions PACT
3548: , pay_assignment_actions OWN_ACT
3549: where PERBAL.defined_balance_id = p_defined_balance_id

Line 3994: , per_all_assignments_f ASSIGN

3990: plb.local_unit_id,
3991: plb.organization_id,
3992: plb.source_number2
3993: from pay_latest_balances plb
3994: , per_all_assignments_f ASSIGN
3995: , pay_assignment_actions ACT
3996: , pay_payroll_actions PACT
3997: , pay_assignment_actions OWN_ACT
3998: where plb.defined_balance_id = p_defined_balance_id

Line 5518: l_payroll_id per_all_assignments_f.payroll_id%type;

5514: p_asg_lock in varchar2
5515: ) return number is
5516: p_balance_result number;
5517: --
5518: l_payroll_id per_all_assignments_f.payroll_id%type;
5519: l_bus_grp_id per_all_assignments_f.business_group_id%type;
5520: l_consol_set_id pay_all_payrolls_f.payroll_id%type;
5521: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
5522: l_pay_action_id pay_payroll_actions.payroll_action_id%type;

Line 5519: l_bus_grp_id per_all_assignments_f.business_group_id%type;

5515: ) return number is
5516: p_balance_result number;
5517: --
5518: l_payroll_id per_all_assignments_f.payroll_id%type;
5519: l_bus_grp_id per_all_assignments_f.business_group_id%type;
5520: l_consol_set_id pay_all_payrolls_f.payroll_id%type;
5521: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
5522: l_pay_action_id pay_payroll_actions.payroll_action_id%type;
5523: l_time_period_id per_time_periods.time_period_id%type;

Line 5555: from per_all_assignments_f ASSIGN

5551: PAYROLL.consolidation_set_id
5552: into l_payroll_id,
5553: l_bus_grp_id,
5554: l_consol_set_id
5555: from per_all_assignments_f ASSIGN
5556: , pay_all_payrolls_f PAYROLL
5557: where ASSIGN.assignment_id = p_assignment_id
5558: and p_virtual_date between ASSIGN.effective_start_date
5559: and ASSIGN.effective_end_date

Line 5692: per_all_assignments_f paf1,

5688: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
5689: paa.assignment_action_id),16))
5690: FROM pay_assignment_actions paa,
5691: pay_payroll_actions ppa,
5692: per_all_assignments_f paf1,
5693: per_all_assignments_f paf2
5694: WHERE
5695: paf1.assignment_id = c_assignment_id
5696: AND c_effective_date between paf1.effective_start_date

Line 5693: per_all_assignments_f paf2

5689: paa.assignment_action_id),16))
5690: FROM pay_assignment_actions paa,
5691: pay_payroll_actions ppa,
5692: per_all_assignments_f paf1,
5693: per_all_assignments_f paf2
5694: WHERE
5695: paf1.assignment_id = c_assignment_id
5696: AND c_effective_date between paf1.effective_start_date
5697: and paf1.effective_end_date

Line 5700: from per_all_assignments_f paf3

5696: AND c_effective_date between paf1.effective_start_date
5697: and paf1.effective_end_date
5698: AND paf2.person_id = paf1.person_id
5699: AND paf2.effective_start_date = (select max(paf3.effective_start_date)
5700: from per_all_assignments_f paf3
5701: where paf3.assignment_id = paf2.assignment_id
5702: and paf3.effective_start_date <= c_effective_date)
5703: AND paf2.assignment_id = paa.assignment_id
5704: AND ppa.payroll_action_id = paa.payroll_action_id