eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BALANCE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 85: g_business_group_id per_all_assignments_f.business_group_id%type;

81: g_assignment_id pay_assignment_actions.assignment_id%type;
82: g_chunk_number pay_assignment_actions.chunk_number%type;
83: g_defined_balance_id pay_defined_balances.defined_balance_id%type;
84: g_balance_type_id pay_defined_balances.balance_type_id%type;
85: g_business_group_id per_all_assignments_f.business_group_id%type;
86:
87: g_feed_input_tab FND_TABLE_OF_NUMBER;
88: g_feed_element_tab FND_TABLE_OF_NUMBER;
89: g_feed_feed_tab FND_TABLE_OF_NUMBER;

Line 3843: , per_all_assignments_f ASSIGN

3839: PERBAL.expired_value,
3840: PERBAL.prev_assignment_action_id,
3841: PERBAL.prev_balance_value
3842: from pay_person_latest_balances PERBAL
3843: , per_all_assignments_f ASSIGN
3844: , pay_assignment_actions ACT
3845: , pay_payroll_actions PACT
3846: , pay_assignment_actions OWN_ACT
3847: where PERBAL.defined_balance_id = p_defined_balance_id

Line 4292: , per_all_assignments_f ASSIGN

4288: plb.local_unit_id,
4289: plb.organization_id,
4290: plb.source_number2
4291: from pay_latest_balances plb
4292: , per_all_assignments_f ASSIGN
4293: , pay_assignment_actions ACT
4294: , pay_payroll_actions PACT
4295: , pay_assignment_actions OWN_ACT
4296: where plb.defined_balance_id = p_defined_balance_id

Line 5820: l_payroll_id per_all_assignments_f.payroll_id%type;

5816: p_asg_lock in varchar2
5817: ) return number is
5818: p_balance_result number;
5819: --
5820: l_payroll_id per_all_assignments_f.payroll_id%type;
5821: l_bus_grp_id per_all_assignments_f.business_group_id%type;
5822: l_consol_set_id pay_all_payrolls_f.payroll_id%type;
5823: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
5824: l_pay_action_id pay_payroll_actions.payroll_action_id%type;

Line 5821: l_bus_grp_id per_all_assignments_f.business_group_id%type;

5817: ) return number is
5818: p_balance_result number;
5819: --
5820: l_payroll_id per_all_assignments_f.payroll_id%type;
5821: l_bus_grp_id per_all_assignments_f.business_group_id%type;
5822: l_consol_set_id pay_all_payrolls_f.payroll_id%type;
5823: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
5824: l_pay_action_id pay_payroll_actions.payroll_action_id%type;
5825: l_time_period_id per_time_periods.time_period_id%type;

Line 5857: from per_all_assignments_f ASSIGN

5853: PAYROLL.consolidation_set_id
5854: into l_payroll_id,
5855: l_bus_grp_id,
5856: l_consol_set_id
5857: from per_all_assignments_f ASSIGN
5858: , pay_all_payrolls_f PAYROLL
5859: where ASSIGN.assignment_id = p_assignment_id
5860: and p_virtual_date between ASSIGN.effective_start_date
5861: and ASSIGN.effective_end_date

Line 5991: FROM per_all_assignments_f paf1,

5987: paa.assignment_action_id),16))
5988: FROM pay_assignment_actions paa,
5989: pay_payroll_actions ppa,
5990: (SELECT DISTINCT paf2.assignment_id
5991: FROM per_all_assignments_f paf1,
5992: per_all_assignments_f paf2
5993: WHERE paf1.assignment_id = c_assignment_id
5994: AND c_effective_date between paf1.effective_start_date
5995: and paf1.effective_end_date

Line 5992: per_all_assignments_f paf2

5988: FROM pay_assignment_actions paa,
5989: pay_payroll_actions ppa,
5990: (SELECT DISTINCT paf2.assignment_id
5991: FROM per_all_assignments_f paf1,
5992: per_all_assignments_f paf2
5993: WHERE paf1.assignment_id = c_assignment_id
5994: AND c_effective_date between paf1.effective_start_date
5995: and paf1.effective_end_date
5996: AND paf2.person_id = paf1.person_id) PAF