APPS.PAY_TRGL_PKG dependencies on PER_ALL_ASSIGNMENTS_F

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

68: adjustments. Bug 3911521.
69: 115.29 alogue 09-DEC-2003 Populate gl_interface.reference25
70: with Runs' payroll_action_id.
71: Bug 3306461.
72: 115.28 alogue 30-OCT-2003 Use per_all_assignments_f,
73: pay_all_payrolls and
74: per_business_groups_perf.
75: 115.27 alogue 23-JUL-2003 Enhance to process run actions for the
76: specified payroll regardless of

Line 547: per_all_assignments_f per,

543: SUM(DECODE(cst.debit_or_credit,''D'',cst.costed_value,null)),
544: SUM(DECODE(cst.debit_or_credit,''C'',cst.costed_value,null))
545: FROM pay_payroll_actions ppa, -- Run payroll action
546: pay_payroll_actions ppa1, -- Cost payroll action
547: per_all_assignments_f per,
548: pay_assignment_actions pa, -- TGL assignment action
549: pay_action_interlocks pi, -- interlock to costing
550: pay_assignment_actions pa1, -- Cost assignment action
551: pay_action_interlocks pi2, -- interlock to run

Line 620: per_all_assignments_f PERA,

616: CST.run_result_id)
617: UNION ALL
618: select RR1.run_result_id
619: FROM pay_run_results RR1,
620: per_all_assignments_f PERA,
621: pay_element_types_f ET1,
622: pay_element_classifications EC,
623: pay_element_links_f EL1
624: WHERE RR1.assignment_action_id = pa2.assignment_action_id

Line 751: per_all_assignments_f per,

747: SUM(DECODE(cst.debit_or_credit,''D'',cst.costed_value,null)),
748: SUM(DECODE(cst.debit_or_credit,''C'',cst.costed_value,null))
749: FROM pay_payroll_actions ppa, -- Run payroll action
750: pay_payroll_actions ppa1, -- Cost payroll action
751: per_all_assignments_f per,
752: pay_assignment_actions pa, -- TGL assignment action
753: pay_action_interlocks pi, -- interlock to costing
754: pay_assignment_actions pa1, -- Cost assignment action
755: pay_action_interlocks pi2, -- interlock to run

Line 824: per_all_assignments_f PERA,

820: CST.run_result_id)
821: UNION ALL
822: select RR1.run_result_id
823: FROM pay_run_results RR1,
824: per_all_assignments_f PERA,
825: pay_element_types_f ET1,
826: pay_element_classifications EC,
827: pay_element_links_f EL1
828: WHERE RR1.assignment_action_id = pa2.assignment_action_id

Line 960: per_all_assignments_f per

956: pay_payroll_actions ppa,
957: pay_action_interlocks pi2, -- Run - Trans GL
958: pay_assignment_actions pa2, -- Payroll run actions.
959: pay_payroll_actions ppa2,
960: per_all_assignments_f per
961: WHERE pi2.locking_action_id = pa.assignment_action_id
962: AND pa.assignment_id = per.assignment_id
963: AND per.payroll_id +0 = c_payroll_id
964: AND pa2.assignment_action_id = pi2.locked_action_id

Line 1066: per_all_assignments_f pera,

1062: pay_assignment_actions pa, -- Trans GL asg actions
1063: pay_action_interlocks pi1, -- Cost - Trans GL
1064: pay_assignment_actions pa1, -- Cost asg actions
1065: pay_payroll_actions ppa1, -- Cost pay actions
1066: per_all_assignments_f pera,
1067: pay_all_payrolls_f pp
1068: WHERE ppa.payroll_action_id = i_action_id
1069: AND pa.payroll_action_id = ppa.payroll_action_id
1070: AND pi1.locking_action_id = pa.assignment_action_id

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

1252: where ppa1.payroll_action_id = c_cost_action_id;
1253: end if;
1254:
1255: -- Avoid double postings for consolidation set estimate costs. Bug 5606113.
1256: -- Join to per_all_assignments_f on Effective date confirming on
1257: -- required payroll. Use string concatenation method to avoid performance hit
1258: -- ie only join to per_all_assignments_f if have to.
1259: if ((c_action_type = 'EC' or c_action_type = 'CP') and
1260: c_pay_id is null) then

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

1254:
1255: -- Avoid double postings for consolidation set estimate costs. Bug 5606113.
1256: -- Join to per_all_assignments_f on Effective date confirming on
1257: -- required payroll. Use string concatenation method to avoid performance hit
1258: -- ie only join to per_all_assignments_f if have to.
1259: if ((c_action_type = 'EC' or c_action_type = 'CP') and
1260: c_pay_id is null) then
1261: hr_utility.set_location('pytrgl.trans_pay_costs_mt',33);
1262: l_asg_tab := 'per_all_assignments_f paf,';

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

1258: -- ie only join to per_all_assignments_f if have to.
1259: if ((c_action_type = 'EC' or c_action_type = 'CP') and
1260: c_pay_id is null) then
1261: hr_utility.set_location('pytrgl.trans_pay_costs_mt',33);
1262: l_asg_tab := 'per_all_assignments_f paf,';
1263: l_asg_join :=
1264: 'AND paf.assignment_id = '||'p'||'a.assignment_id
1265: AND :c_run_date between paf.effective_start_date
1266: and paf.effective_end_date

Line 1716: per_all_assignments_f PERA

1712: RR1.run_result_id
1713: FROM pay_run_results RR1,
1714: pay_element_types_f ET1,
1715: pay_element_links_f EL1,
1716: per_all_assignments_f PERA
1717: WHERE RR1.assignment_action_id = raa.assignment_action_id
1718: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,
1719: CST.run_result_id)
1720: AND (

Line 1825: per_all_assignments_f pera,

1821: 'EVE', ptp.end_date,
1822: ptp.pay_advice_date + pay.pay_date_offset)
1823: INTO l_accounting_date
1824: FROM pay_payroll_actions ppa,
1825: per_all_assignments_f pera,
1826: pay_all_payrolls_f pay,
1827: per_time_periods ptp
1828: WHERE ppa.payroll_action_id = c_payroll_action_id
1829: AND pera.assignment_id = r_assignment_id

Line 1877: FROM per_all_assignments_f PERA,

1873: (CST.transfer_to_gl_flag is null
1874: AND EXISTS
1875: (select /*+ ORDERED */
1876: 1
1877: FROM per_all_assignments_f PERA,
1878: pay_element_links_f EL1
1879: WHERE EL1.element_type_id = ET.element_type_id
1880: AND ppa.effective_date BETWEEN EL1.effective_start_date
1881: AND EL1.effective_end_date