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_NL_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 236: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

232: ,p_token in varchar2
233: ,p_segment_number in number default null ) RETURN varchar2
234: IS
235:
236: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
237: l_start_pos NUMBER;
238: l_delimiter varchar2(1):=' ';
239: l_proc VARCHAR2(40):= g_package||' get parameter ';
240:

Line 297: FROM pay_payroll_actions

293: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'START_DATE')
294: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'END_DATE')
295: ,effective_date
296: ,business_group_id
297: FROM pay_payroll_actions
298: WHERE payroll_action_id = p_payroll_action_id;
299:
300: --
301:

Line 621: pay_payroll_actions pact

617: ,pact.effective_date effective_date
618: ,pact.date_earned date_earned
619: ,pact.pay_advice_message payroll_message
620: FROM pay_payrolls_f ppf,
621: pay_payroll_actions pact
622: WHERE pact.payroll_id = ppf.payroll_id
623: AND pact.effective_date BETWEEN ppf.effective_start_date
624: AND ppf.effective_end_date
625: AND pact.payroll_id = p_payroll_id

Line 790: ,pay_payroll_actions ppa

786: --hr_utility.set_location('outside loop',300);
787:
788: sqlstr := 'SELECT DISTINCT person_id
789: FROM per_people_f ppf
790: ,pay_payroll_actions ppa
791: WHERE ppa.payroll_action_id = :payroll_action_id
792: AND ppa.business_group_id = ppf.business_group_id
793: ORDER BY ppf.person_id';
794:

Line 832: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)

828: l_canonical_start_date DATE,
829: l_canonical_end_date DATE) IS
830: -- Andy's changes for bug 5107780
831: SELECT /*+ ORDERED
832: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
833: INDEX(as1 PER_ASSIGNMENTS_F_N12)
834: INDEX(ppf PAY_PAYROLLS_F_PK)
835: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
836: INDEX(appa PAY_PAYROLL_ACTIONS_PK)

Line 836: INDEX(appa PAY_PAYROLL_ACTIONS_PK)

832: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
833: INDEX(as1 PER_ASSIGNMENTS_F_N12)
834: INDEX(ppf PAY_PAYROLLS_F_PK)
835: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
836: INDEX(appa PAY_PAYROLL_ACTIONS_PK)
837: INDEX(pai PAY_ACTION_INTERLOCKS_FK2)
838: INDEX(act1 PAY_ASSIGNMENT_ACTIONS_PK)
839: INDEX(appa2 PAY_PAYROLL_ACTIONS_PK)
840: USE_NL(ppa as1 ppf act appa pai act1 appa2) */

Line 839: INDEX(appa2 PAY_PAYROLL_ACTIONS_PK)

835: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
836: INDEX(appa PAY_PAYROLL_ACTIONS_PK)
837: INDEX(pai PAY_ACTION_INTERLOCKS_FK2)
838: INDEX(act1 PAY_ASSIGNMENT_ACTIONS_PK)
839: INDEX(appa2 PAY_PAYROLL_ACTIONS_PK)
840: USE_NL(ppa as1 ppf act appa pai act1 appa2) */
841: act.assignment_id assignment_id,
842: act.assignment_action_id run_action_id,
843: act1.assignment_action_id prepaid_action_id

Line 844: FROM pay_payroll_actions ppa,

840: USE_NL(ppa as1 ppf act appa pai act1 appa2) */
841: act.assignment_id assignment_id,
842: act.assignment_action_id run_action_id,
843: act1.assignment_action_id prepaid_action_id
844: FROM pay_payroll_actions ppa,
845: per_all_assignments_f as1,
846: pay_assignment_actions act,
847: pay_payroll_actions appa,
848: pay_action_interlocks pai,

Line 847: pay_payroll_actions appa,

843: act1.assignment_action_id prepaid_action_id
844: FROM pay_payroll_actions ppa,
845: per_all_assignments_f as1,
846: pay_assignment_actions act,
847: pay_payroll_actions appa,
848: pay_action_interlocks pai,
849: pay_assignment_actions act1,
850: pay_payroll_actions appa2,
851: pay_payrolls_f ppf

Line 850: pay_payroll_actions appa2,

846: pay_assignment_actions act,
847: pay_payroll_actions appa,
848: pay_action_interlocks pai,
849: pay_assignment_actions act1,
850: pay_payroll_actions appa2,
851: pay_payrolls_f ppf
852: WHERE ppa.payroll_action_id = p_pact_id
853: AND appa.consolidation_set_id = p_consolidation_id
854: AND appa.effective_date BETWEEN l_canonical_start_date AND l_canonical_end_date

Line 881: pay_payroll_actions appa3

877: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
878: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
879: FROM pay_action_interlocks pai1,
880: pay_assignment_actions act2,
881: pay_payroll_actions appa3
882: WHERE pai1.locked_action_id = act.assignment_action_id
883: AND act2.assignment_action_id= pai1.locking_action_id
884: AND act2.payroll_action_id = appa3.payroll_action_id
885: AND appa3.action_type = 'X'

Line 891: pay_payroll_actions appa3

887: AND appa3.report_type = 'NL_PS_ARCHIVE')
888: AND NOT EXISTS ( SELECT /*+ ORDERED */ NULL
889: FROM pay_action_interlocks pai1,
890: pay_assignment_actions act2,
891: pay_payroll_actions appa3
892: WHERE pai1.locked_action_id = act.assignment_action_id
893: AND act2.assignment_action_id= pai1.locking_action_id
894: AND act2.payroll_action_id = appa3.payroll_action_id
895: AND appa3.action_type = 'V'

Line 3906: pay_payroll_actions paa,

3902: paa.time_period_id time_period_id,
3903: paa.payroll_id payroll_id
3904: FROM pay_action_interlocks pre,
3905: pay_action_interlocks pay,
3906: pay_payroll_actions paa,
3907: pay_payroll_actions ppaa,
3908: pay_assignment_actions assact,
3909: pay_assignment_actions passact
3910: WHERE pre.locked_action_id = pay.locking_action_id

Line 3907: pay_payroll_actions ppaa,

3903: paa.payroll_id payroll_id
3904: FROM pay_action_interlocks pre,
3905: pay_action_interlocks pay,
3906: pay_payroll_actions paa,
3907: pay_payroll_actions ppaa,
3908: pay_assignment_actions assact,
3909: pay_assignment_actions passact
3910: WHERE pre.locked_action_id = pay.locking_action_id
3911: AND pre.locking_action_id = lp_locking_action_id

Line 6072: pay_payroll_actions paa,

6068: paa.time_period_id time_period_id,
6069: paa.payroll_id payroll_id
6070: FROM pay_action_interlocks pre,
6071: pay_action_interlocks pay,
6072: pay_payroll_actions paa,
6073: pay_payroll_actions ppaa,
6074: pay_assignment_actions assact,
6075: pay_assignment_actions passact
6076: WHERE pre.locked_action_id = pay.locking_action_id

Line 6073: pay_payroll_actions ppaa,

6069: paa.payroll_id payroll_id
6070: FROM pay_action_interlocks pre,
6071: pay_action_interlocks pay,
6072: pay_payroll_actions paa,
6073: pay_payroll_actions ppaa,
6074: pay_assignment_actions assact,
6075: pay_assignment_actions passact
6076: WHERE pre.locked_action_id = pay.locking_action_id
6077: AND pre.locking_action_id = p_locking_action_id

Line 6090: pay_payroll_actions ppa,

6086:
6087: cursor csr_get_max_assignment_action(p_assignment_action_id NUMBER)
6088: is
6089: select max(paa.assignment_Action_id) max_assact from
6090: pay_payroll_actions ppa,
6091: pay_assignment_Actions paa,
6092: pay_assignment_Actions paa1
6093: where paa1.assignment_Action_id = p_assignment_action_id
6094: and paa1.payroll_action_id = ppa.payroll_action_id

Line 6162: ,pay_payroll_actions ppa

6158: SELECT ptp.end_date end_date,
6159: ptp.regular_payment_date regular_payment_date,
6160: ptp.time_period_id time_period_id
6161: FROM per_time_periods ptp
6162: ,pay_payroll_actions ppa
6163: ,pay_assignment_actions paa
6164: WHERE ptp.payroll_id =ppa.payroll_id
6165: AND ppa.payroll_action_id =paa.payroll_action_id
6166: And paa.assignment_action_id =p_assignment_action_id