APPS.PAY_TRGL_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 65: 115.28 alogue 30-OCT-2003 Use per_all_assignments_f,

61: adjustments. Bug 3911521.
62: 115.29 alogue 09-DEC-2003 Populate gl_interface.reference25
63: with Runs' payroll_action_id.
64: Bug 3306461.
65: 115.28 alogue 30-OCT-2003 Use per_all_assignments_f,
66: pay_all_payrolls and
67: per_business_groups_perf.
68: 115.27 alogue 23-JUL-2003 Enhance to process run actions for the
69: specified payroll regardless of

Line 540: per_all_assignments_f per,

536: SUM(DECODE(cst.debit_or_credit,''D'',cst.costed_value,0)),
537: SUM(DECODE(cst.debit_or_credit,''C'',cst.costed_value,0))
538: FROM pay_payroll_actions ppa, -- Run payroll action
539: pay_payroll_actions ppa1, -- Cost payroll action
540: per_all_assignments_f per,
541: pay_assignment_actions pa, -- TGL assignment action
542: pay_action_interlocks pi, -- interlock to costing
543: pay_assignment_actions pa1, -- Cost assignment action
544: pay_action_interlocks pi2, -- interlock to run

Line 613: per_all_assignments_f PERA,

609: CST.run_result_id)
610: UNION ALL
611: select RR1.run_result_id
612: FROM pay_run_results RR1,
613: per_all_assignments_f PERA,
614: pay_element_types_f ET1,
615: pay_element_classifications EC,
616: pay_element_links_f EL1
617: WHERE RR1.assignment_action_id = pa2.assignment_action_id

Line 744: per_all_assignments_f per,

740: SUM(DECODE(cst.debit_or_credit,''D'',cst.costed_value,0)),
741: SUM(DECODE(cst.debit_or_credit,''C'',cst.costed_value,0))
742: FROM pay_payroll_actions ppa, -- Run payroll action
743: pay_payroll_actions ppa1, -- Cost payroll action
744: per_all_assignments_f per,
745: pay_assignment_actions pa, -- TGL assignment action
746: pay_action_interlocks pi, -- interlock to costing
747: pay_assignment_actions pa1, -- Cost assignment action
748: pay_action_interlocks pi2, -- interlock to run

Line 817: per_all_assignments_f PERA,

813: CST.run_result_id)
814: UNION ALL
815: select RR1.run_result_id
816: FROM pay_run_results RR1,
817: per_all_assignments_f PERA,
818: pay_element_types_f ET1,
819: pay_element_classifications EC,
820: pay_element_links_f EL1
821: WHERE RR1.assignment_action_id = pa2.assignment_action_id

Line 953: per_all_assignments_f per

949: pay_payroll_actions ppa,
950: pay_action_interlocks pi2, -- Run - Trans GL
951: pay_assignment_actions pa2, -- Payroll run actions.
952: pay_payroll_actions ppa2,
953: per_all_assignments_f per
954: WHERE pi2.locking_action_id = pa.assignment_action_id
955: AND pa.assignment_id = per.assignment_id
956: AND per.payroll_id +0 = c_payroll_id
957: AND pa2.assignment_action_id = pi2.locked_action_id

Line 1047: per_all_assignments_f pera,

1043: pay_assignment_actions pa, -- Trans GL asg actions
1044: pay_action_interlocks pi1, -- Cost - Trans GL
1045: pay_assignment_actions pa1, -- Cost asg actions
1046: pay_payroll_actions ppa1, -- Cost pay actions
1047: per_all_assignments_f pera,
1048: pay_all_payrolls_f pp
1049: WHERE ppa.payroll_action_id = i_action_id
1050: AND pa.payroll_action_id = ppa.payroll_action_id
1051: AND pi1.locking_action_id = pa.assignment_action_id

Line 1237: -- Join to per_all_assignments_f on Effective date confirming on

1233: where ppa1.payroll_action_id = c_cost_action_id;
1234: end if;
1235:
1236: -- Avoid double postings for consolidation set estimate costs. Bug 5606113.
1237: -- Join to per_all_assignments_f on Effective date confirming on
1238: -- required payroll. Use string concatenation method to avoid performance hit
1239: -- ie only join to per_all_assignments_f if have to.
1240: if ((c_action_type = 'EC' or c_action_type = 'CP') and
1241: c_pay_id is null) then

Line 1239: -- ie only join to per_all_assignments_f if have to.

1235:
1236: -- Avoid double postings for consolidation set estimate costs. Bug 5606113.
1237: -- Join to per_all_assignments_f on Effective date confirming on
1238: -- required payroll. Use string concatenation method to avoid performance hit
1239: -- ie only join to per_all_assignments_f if have to.
1240: if ((c_action_type = 'EC' or c_action_type = 'CP') and
1241: c_pay_id is null) then
1242: hr_utility.set_location('pytrgl.trans_pay_costs_mt',33);
1243: l_asg_tab := 'per_all_assignments_f paf,';

Line 1243: l_asg_tab := 'per_all_assignments_f paf,';

1239: -- ie only join to per_all_assignments_f if have to.
1240: if ((c_action_type = 'EC' or c_action_type = 'CP') and
1241: c_pay_id is null) then
1242: hr_utility.set_location('pytrgl.trans_pay_costs_mt',33);
1243: l_asg_tab := 'per_all_assignments_f paf,';
1244: l_asg_join :=
1245: 'AND paf.assignment_id = '||'p'||'a.assignment_id
1246: AND :c_run_date between paf.effective_start_date
1247: and paf.effective_end_date

Line 1697: per_all_assignments_f PERA

1693: RR1.run_result_id
1694: FROM pay_run_results RR1,
1695: pay_element_types_f ET1,
1696: pay_element_links_f EL1,
1697: per_all_assignments_f PERA
1698: WHERE RR1.assignment_action_id = raa.assignment_action_id
1699: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,
1700: CST.run_result_id)
1701: AND (

Line 1806: per_all_assignments_f pera,

1802: 'EVE', ptp.end_date,
1803: ptp.pay_advice_date + pay.pay_date_offset)
1804: INTO l_accounting_date
1805: FROM pay_payroll_actions ppa,
1806: per_all_assignments_f pera,
1807: pay_all_payrolls_f pay,
1808: per_time_periods ptp
1809: WHERE ppa.payroll_action_id = c_payroll_action_id
1810: AND pera.assignment_id = r_assignment_id

Line 1858: FROM per_all_assignments_f PERA,

1854: (CST.transfer_to_gl_flag is null
1855: AND EXISTS
1856: (select /*+ ORDERED */
1857: 1
1858: FROM per_all_assignments_f PERA,
1859: pay_element_links_f EL1
1860: WHERE EL1.element_type_id = ET.element_type_id
1861: AND ppa.effective_date BETWEEN EL1.effective_start_date
1862: AND EL1.effective_end_date