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 80: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

76: g_tgl_date_used pay_action_parameter_values.parameter_value%TYPE := null;
77: --
78: -- Caches for get_ecost_accounting_date
79: --
80: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
81: g_cost_date date := null;
82: g_accounting_date date := null;
83: --
84: PROCEDURE trans_asg_costs

Line 105: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;

101: r_action_type pay_payroll_actions.action_type%TYPE;
102: r_assignment_id NUMBER;
103: c_action_type pay_payroll_actions.action_type%TYPE;
104: c_effective_date DATE;
105: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;
106: l_accounting_date DATE;
107: l_rev_accounting_date DATE;
108: l_event_id NUMBER;
109: --

Line 171: pay_all_payrolls_f pap

167: FROM pay_assignment_actions pa, -- TGL assignment action
168: pay_action_interlocks pi2, -- interlock to run
169: pay_assignment_actions pa2, -- run assignment action
170: pay_payroll_actions ppa2,-- run payroll action
171: pay_all_payrolls_f pap
172: WHERE pa.assignment_action_id = i_assignment_action_id
173: AND pi2.locking_action_id = pa.assignment_action_id
174: AND pa2.assignment_action_id = pi2.locked_action_id
175: AND ppa2.payroll_action_id = pa2.payroll_action_id

Line 251: pay_all_payrolls_f pap

247: pap.gl_set_of_books_id
248: INTO l_rev_accounting_date,
249: l_ledger_id
250: FROM per_all_assignments_f pera,
251: pay_all_payrolls_f pap
252: WHERE pera.assignment_id = r_assignment_id
253: AND c_effective_date BETWEEN pera.effective_start_date
254: AND pera.effective_end_date
255: AND pap.payroll_id = pera.payroll_id

Line 322: pay_all_payrolls_f pap

318:
319: SELECT pap.gl_set_of_books_id
320: INTO l_ledger_id
321: FROM per_all_assignments_f pera,
322: pay_all_payrolls_f pap
323: WHERE pera.assignment_id = r_assignment_id
324: AND c_effective_date BETWEEN pera.effective_start_date
325: AND pera.effective_end_date
326: AND pap.payroll_id = pera.payroll_id

Line 561: FROM pay_all_payrolls_f pay,

557: decode(g_tgl_date_used, 'E', ptp.end_date,
558: 'EVE', ptp.end_date,
559: ptp.pay_advice_date + pay.pay_date_offset)
560: INTO l_accounting_date
561: FROM pay_all_payrolls_f pay,
562: per_time_periods ptp
563: WHERE pay.payroll_id = ecost_payroll_id
564: AND cost_effective_date BETWEEN pay.effective_start_date
565: AND pay.effective_end_date

Line 651: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;

647: FROM PAY_XLA_EVENTS PAYE
648: WHERE PAYE.assignment_action_id = i_assignment_action_id;
649:
650: l_completed_events number;
651: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;
652: l_event_source_info xla_events_pub_pkg.t_event_source_info;
653: l_security_context xla_events_pub_pkg.t_security;
654:
655: BEGIN

Line 684: pay_all_payrolls_f pap

680: FROM pay_assignment_actions pa, -- TGL assignment action
681: pay_action_interlocks pi, -- interlock to cost
682: pay_assignment_actions pa1, -- cost assignment action
683: pay_payroll_actions ppa1,-- cost payroll action
684: pay_all_payrolls_f pap
685: WHERE pa.assignment_action_id = i_assignment_action_id
686: AND pi.locking_action_id = pa.assignment_action_id
687: AND pa1.assignment_action_id = pi.locked_action_id
688: AND ppa1.payroll_action_id = pa1.payroll_action_id

Line 704: pay_all_payrolls_f pap,

700: FROM pay_assignment_actions pa, -- TGL assignment action
701: pay_action_interlocks pi, -- interlock to run
702: pay_assignment_actions pa1, -- run assignment action
703: pay_payroll_actions ppa1,-- run payroll action
704: pay_all_payrolls_f pap,
705: per_all_assignments_f paf
706: WHERE pa.assignment_action_id = i_assignment_action_id
707: AND pi.locking_action_id = pa.assignment_action_id
708: AND pa1.assignment_action_id = pi.locked_action_id

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

784: l_segment_rule_code xla_rules_t.segment_rule_code%type;
785: l_coa_id xla_rules_t.accounting_coa_id%type;
786: l_acc_segment xla_rules_t.flexfield_segment_code%type;
787: l_pay_segment xla_rules_t.flexfield_segment_code%type;
788: l_prev_payroll_id pay_all_payrolls_f.payroll_id%type := -1;
789: l_payroll_name pay_all_payrolls_f.payroll_name%type;
790: l_rule_det_seq xla_rule_details_t.user_sequence%type;
791: --
792: BEGIN

Line 789: l_payroll_name pay_all_payrolls_f.payroll_name%type;

785: l_coa_id xla_rules_t.accounting_coa_id%type;
786: l_acc_segment xla_rules_t.flexfield_segment_code%type;
787: l_pay_segment xla_rules_t.flexfield_segment_code%type;
788: l_prev_payroll_id pay_all_payrolls_f.payroll_id%type := -1;
789: l_payroll_name pay_all_payrolls_f.payroll_name%type;
790: l_rule_det_seq xla_rule_details_t.user_sequence%type;
791: --
792: BEGIN
793: --

Line 807: from pay_all_payrolls_f

803:
804: if (segmap.payroll_id <> l_prev_payroll_id) then
805: select payroll_name
806: into l_payroll_name
807: from pay_all_payrolls_f
808: where payroll_id = segmap.payroll_id
809: and rownum < 2;
810:
811: l_prev_payroll_id := segmap.payroll_id;