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_SLA_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 73: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

69: g_tgl_date_used pay_action_parameter_values.parameter_value%TYPE := null;
70: --
71: -- Caches for get_ecost_accounting_date
72: --
73: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
74: g_cost_date date := null;
75: g_accounting_date date := null;
76: --
77: PROCEDURE trans_asg_costs

Line 98: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;

94: r_action_type pay_payroll_actions.action_type%TYPE;
95: r_assignment_id NUMBER;
96: c_action_type pay_payroll_actions.action_type%TYPE;
97: c_effective_date DATE;
98: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;
99: l_accounting_date DATE;
100: l_rev_accounting_date DATE;
101: l_event_id NUMBER;
102: --

Line 164: pay_all_payrolls_f pap

160: FROM pay_assignment_actions pa, -- TGL assignment action
161: pay_action_interlocks pi2, -- interlock to run
162: pay_assignment_actions pa2, -- run assignment action
163: pay_payroll_actions ppa2,-- run payroll action
164: pay_all_payrolls_f pap
165: WHERE pa.assignment_action_id = i_assignment_action_id
166: AND pi2.locking_action_id = pa.assignment_action_id
167: AND pa2.assignment_action_id = pi2.locked_action_id
168: AND ppa2.payroll_action_id = pa2.payroll_action_id

Line 241: pay_all_payrolls_f pap

237: pap.gl_set_of_books_id
238: INTO l_rev_accounting_date,
239: l_ledger_id
240: FROM per_all_assignments_f pera,
241: pay_all_payrolls_f pap
242: WHERE pera.assignment_id = r_assignment_id
243: AND c_effective_date BETWEEN pera.effective_start_date
244: AND pera.effective_end_date
245: AND pap.payroll_id = pera.payroll_id

Line 312: pay_all_payrolls_f pap

308:
309: SELECT pap.gl_set_of_books_id
310: INTO l_ledger_id
311: FROM per_all_assignments_f pera,
312: pay_all_payrolls_f pap
313: WHERE pera.assignment_id = r_assignment_id
314: AND c_effective_date BETWEEN pera.effective_start_date
315: AND pera.effective_end_date
316: AND pap.payroll_id = pera.payroll_id

Line 551: FROM pay_all_payrolls_f pay,

547: decode(g_tgl_date_used, 'E', ptp.end_date,
548: 'EVE', ptp.end_date,
549: ptp.pay_advice_date + pay.pay_date_offset)
550: INTO l_accounting_date
551: FROM pay_all_payrolls_f pay,
552: per_time_periods ptp
553: WHERE pay.payroll_id = ecost_payroll_id
554: AND cost_effective_date BETWEEN pay.effective_start_date
555: AND pay.effective_end_date

Line 641: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;

637: FROM PAY_XLA_EVENTS PAYE
638: WHERE PAYE.assignment_action_id = i_assignment_action_id;
639:
640: l_completed_events number;
641: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;
642: l_event_source_info xla_events_pub_pkg.t_event_source_info;
643: l_security_context xla_events_pub_pkg.t_security;
644:
645: BEGIN

Line 673: pay_all_payrolls_f pap

669: FROM pay_assignment_actions pa, -- TGL assignment action
670: pay_action_interlocks pi, -- interlock to cost
671: pay_assignment_actions pa1, -- cost assignment action
672: pay_payroll_actions ppa1,-- cost payroll action
673: pay_all_payrolls_f pap
674: WHERE pa.assignment_action_id = i_assignment_action_id
675: AND pi.locking_action_id = pa.assignment_action_id
676: AND pa1.assignment_action_id = pi.locked_action_id
677: AND ppa1.payroll_action_id = pa1.payroll_action_id

Line 691: pay_all_payrolls_f pap

687: FROM pay_assignment_actions pa, -- TGL assignment action
688: pay_action_interlocks pi, -- interlock to run
689: pay_assignment_actions pa1, -- run assignment action
690: pay_payroll_actions ppa1,-- run payroll action
691: pay_all_payrolls_f pap
692: WHERE pa.assignment_action_id = i_assignment_action_id
693: AND pi.locking_action_id = pa.assignment_action_id
694: AND pa1.assignment_action_id = pi.locked_action_id
695: AND ppa1.payroll_action_id = pa1.payroll_action_id

Line 769: l_prev_payroll_id pay_all_payrolls_f.payroll_id%type := -1;

765: l_segment_rule_code xla_rules_t.segment_rule_code%type;
766: l_coa_id xla_rules_t.accounting_coa_id%type;
767: l_acc_segment xla_rules_t.flexfield_segment_code%type;
768: l_pay_segment xla_rules_t.flexfield_segment_code%type;
769: l_prev_payroll_id pay_all_payrolls_f.payroll_id%type := -1;
770: l_payroll_name pay_all_payrolls_f.payroll_name%type;
771: l_rule_det_seq xla_rule_details_t.user_sequence%type;
772: --
773: BEGIN

Line 770: l_payroll_name pay_all_payrolls_f.payroll_name%type;

766: l_coa_id xla_rules_t.accounting_coa_id%type;
767: l_acc_segment xla_rules_t.flexfield_segment_code%type;
768: l_pay_segment xla_rules_t.flexfield_segment_code%type;
769: l_prev_payroll_id pay_all_payrolls_f.payroll_id%type := -1;
770: l_payroll_name pay_all_payrolls_f.payroll_name%type;
771: l_rule_det_seq xla_rule_details_t.user_sequence%type;
772: --
773: BEGIN
774: --

Line 788: from pay_all_payrolls_f

784:
785: if (segmap.payroll_id <> l_prev_payroll_id) then
786: select payroll_name
787: into l_payroll_name
788: from pay_all_payrolls_f
789: where payroll_id = segmap.payroll_id
790: and rownum < 2;
791:
792: l_prev_payroll_id := segmap.payroll_id;