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

Line 76: FROM pay_payroll_actions

72: INSTR(legislative_parameters,' ',
73: INSTR(legislative_parameters,p_token))
74: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token))),
75: business_group_id
76: FROM pay_payroll_actions
77: WHERE payroll_action_id = p_pact_id;
78:
79: l_business_group_id VARCHAR2(20);
80: l_token_value VARCHAR2(50);

Line 597: FROM pay_payroll_actions

593: IS
594:
595: CURSOR csr_archive_effective_date(pactid NUMBER) IS
596: SELECT effective_date
597: FROM pay_payroll_actions
598: WHERE payroll_action_id = pactid;
599:
600: CURSOR csr_input_value_id(p_element_name CHAR,
601: p_value_name CHAR) IS

Line 1447: pay_payroll_actions pact,

1443: ppf.payroll_name payroll_name,
1444: ppf.period_type period_type,
1445: pact.pay_advice_message payroll_message
1446: FROM pay_payrolls_f ppf,
1447: pay_payroll_actions pact,
1448: hr_soft_coding_keyflex flex,
1449: hr_organization_information org
1450: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1451: AND org.org_information_context = 'Tax Details References'

Line 1478: pay_payroll_actions pact

1474: pact.effective_date effective_date,
1475: pact.date_earned date_earned,
1476: pact.pay_advice_message payroll_message
1477: FROM pay_payrolls_f ppf,
1478: pay_payroll_actions pact
1479: WHERE pact.payroll_id = ppf.payroll_id
1480: AND pact.effective_date BETWEEN
1481: ppf.effective_start_date AND ppf.effective_end_date
1482: AND pact.payroll_id = p_payroll_id

Line 1689: pay_payroll_actions ppa

1685: --
1686: hr_utility.trace('Range Cursor Not using Payroll Restriction');
1687: sqlstr := 'SELECT DISTINCT person_id
1688: FROM per_people_f ppf,
1689: pay_payroll_actions ppa
1690: WHERE ppa.payroll_action_id = :payroll_action_id
1691: AND ppa.business_group_id +0= ppf.business_group_id
1692: ORDER BY ppf.person_id';
1693: else

Line 1700: pay_payroll_actions ppa,

1696: --
1697: hr_utility.trace('Range Cursor using Payroll Restriction');
1698: sqlstr := 'SELECT DISTINCT ppf.person_id
1699: FROM per_all_people_f ppf,
1700: pay_payroll_actions ppa,
1701: per_all_assignments_f paaf
1702: WHERE ppa.payroll_action_id = :payroll_action_id
1703: AND ppf.business_group_id +0 = ppa.business_group_id
1704: AND paaf.person_id = ppf.person_id

Line 1781: FROM pay_payroll_actions ppa,

1777: p_consolidation_id NUMBER) IS
1778: SELECT act.assignment_id assignment_id,
1779: act.assignment_action_id run_action_id,
1780: act1.assignment_action_id prepaid_action_id
1781: FROM pay_payroll_actions ppa,
1782: pay_payroll_actions appa,
1783: pay_payroll_actions appa2,
1784: pay_assignment_actions act,
1785: pay_assignment_actions act1,

Line 1782: pay_payroll_actions appa,

1778: SELECT act.assignment_id assignment_id,
1779: act.assignment_action_id run_action_id,
1780: act1.assignment_action_id prepaid_action_id
1781: FROM pay_payroll_actions ppa,
1782: pay_payroll_actions appa,
1783: pay_payroll_actions appa2,
1784: pay_assignment_actions act,
1785: pay_assignment_actions act1,
1786: pay_action_interlocks pai,

Line 1783: pay_payroll_actions appa2,

1779: act.assignment_action_id run_action_id,
1780: act1.assignment_action_id prepaid_action_id
1781: FROM pay_payroll_actions ppa,
1782: pay_payroll_actions appa,
1783: pay_payroll_actions appa2,
1784: pay_assignment_actions act,
1785: pay_assignment_actions act1,
1786: pay_action_interlocks pai,
1787: per_all_assignments_f as1

Line 1810: pay_payroll_actions appa3

1806: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
1807: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
1808: FROM pay_action_interlocks pai1,
1809: pay_assignment_actions act2,
1810: pay_payroll_actions appa3
1811: WHERE pai1.locked_action_id = act.assignment_action_id
1812: AND act2.assignment_action_id = pai1.locking_action_id
1813: AND act2.payroll_action_id = appa3.payroll_action_id
1814: AND appa3.action_type = 'X'

Line 1829: FROM pay_payroll_actions ppa,

1825: p_consolidation_id NUMBER) IS
1826: SELECT act.assignment_id assignment_id,
1827: act.assignment_action_id run_action_id,
1828: act1.assignment_action_id prepaid_action_id
1829: FROM pay_payroll_actions ppa,
1830: pay_payroll_actions appa,
1831: pay_payroll_actions appa2,
1832: pay_assignment_actions act,
1833: pay_assignment_actions act1,

Line 1830: pay_payroll_actions appa,

1826: SELECT act.assignment_id assignment_id,
1827: act.assignment_action_id run_action_id,
1828: act1.assignment_action_id prepaid_action_id
1829: FROM pay_payroll_actions ppa,
1830: pay_payroll_actions appa,
1831: pay_payroll_actions appa2,
1832: pay_assignment_actions act,
1833: pay_assignment_actions act1,
1834: pay_action_interlocks pai,

Line 1831: pay_payroll_actions appa2,

1827: act.assignment_action_id run_action_id,
1828: act1.assignment_action_id prepaid_action_id
1829: FROM pay_payroll_actions ppa,
1830: pay_payroll_actions appa,
1831: pay_payroll_actions appa2,
1832: pay_assignment_actions act,
1833: pay_assignment_actions act1,
1834: pay_action_interlocks pai,
1835: per_all_assignments_f as1,

Line 1860: pay_payroll_actions appa3

1856: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
1857: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
1858: FROM pay_action_interlocks pai1,
1859: pay_assignment_actions act2,
1860: pay_payroll_actions appa3
1861: WHERE pai1.locked_action_id = act.assignment_action_id
1862: AND act2.assignment_action_id = pai1.locking_action_id
1863: AND act2.payroll_action_id = appa3.payroll_action_id
1864: AND appa3.action_type = 'X'

Line 2004: pay_payroll_actions paa,

2000: paa.date_earned date_earned,
2001: paa.time_period_id time_period_id
2002: FROM pay_action_interlocks pre,
2003: pay_action_interlocks pay,
2004: pay_payroll_actions paa,
2005: pay_payroll_actions ppaa,
2006: pay_assignment_actions assact,
2007: pay_assignment_actions passact
2008: WHERE pre.locked_action_id = pay.locking_action_id

Line 2005: pay_payroll_actions ppaa,

2001: paa.time_period_id time_period_id
2002: FROM pay_action_interlocks pre,
2003: pay_action_interlocks pay,
2004: pay_payroll_actions paa,
2005: pay_payroll_actions ppaa,
2006: pay_assignment_actions assact,
2007: pay_assignment_actions passact
2008: WHERE pre.locked_action_id = pay.locking_action_id
2009: AND pre.locking_action_id = p_locking_action_id

Line 2357: pay_payroll_actions pact,

2353: ppf.payroll_name payroll_name,
2354: ppf.period_type period_type,
2355: pact.pay_advice_message payroll_message
2356: FROM pay_payrolls_f ppf,
2357: pay_payroll_actions pact,
2358: hr_soft_coding_keyflex flex,
2359: hr_organization_information org
2360: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
2361: AND org.org_information_context = 'Tax Details References'

Line 2388: pay_payroll_actions pact

2384: pact.effective_date effective_date,
2385: pact.date_earned date_earned,
2386: pact.pay_advice_message payroll_message
2387: FROM pay_payrolls_f ppf,
2388: pay_payroll_actions pact
2389: WHERE pact.payroll_id = ppf.payroll_id
2390: AND pact.effective_date BETWEEN
2391: ppf.effective_start_date AND ppf.effective_end_date
2392: AND pact.payroll_id = p_payroll_id