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 78: FROM pay_payroll_actions

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

Line 634: FROM pay_payroll_actions

630: IS
631:
632: CURSOR csr_archive_effective_date(pactid NUMBER) IS
633: SELECT effective_date
634: FROM pay_payroll_actions
635: WHERE payroll_action_id = pactid;
636:
637: CURSOR csr_input_value_id(p_element_name CHAR,
638: p_value_name CHAR) IS

Line 1513: pay_payroll_actions pact,

1509: ppf.payroll_name payroll_name,
1510: ppf.period_type period_type,
1511: pact.pay_advice_message payroll_message
1512: FROM pay_payrolls_f ppf,
1513: pay_payroll_actions pact,
1514: hr_soft_coding_keyflex flex,
1515: hr_organization_information org
1516: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1517: AND org.org_information_context = 'Tax Details References'

Line 1544: pay_payroll_actions pact

1540: pact.effective_date effective_date,
1541: pact.date_earned date_earned,
1542: pact.pay_advice_message payroll_message
1543: FROM pay_payrolls_f ppf,
1544: pay_payroll_actions pact
1545: WHERE pact.payroll_id = ppf.payroll_id
1546: AND pact.effective_date BETWEEN
1547: ppf.effective_start_date AND ppf.effective_end_date
1548: AND pact.payroll_id = p_payroll_id

Line 1756: pay_payroll_actions ppa

1752: --
1753: hr_utility.trace('Range Cursor Not using Payroll Restriction');
1754: sqlstr := 'SELECT DISTINCT person_id
1755: FROM per_people_f ppf,
1756: pay_payroll_actions ppa
1757: WHERE ppa.payroll_action_id = :payroll_action_id
1758: AND ppa.business_group_id +0= ppf.business_group_id
1759: ORDER BY ppf.person_id';
1760: else

Line 1767: pay_payroll_actions ppa,

1763: --
1764: hr_utility.trace('Range Cursor using Payroll Restriction');
1765: sqlstr := 'SELECT DISTINCT ppf.person_id
1766: FROM per_all_people_f ppf,
1767: pay_payroll_actions ppa,
1768: per_all_assignments_f paaf
1769: WHERE ppa.payroll_action_id = :payroll_action_id
1770: AND ppf.business_group_id +0 = ppa.business_group_id
1771: AND paaf.person_id = ppf.person_id

Line 1848: FROM pay_payroll_actions ppa,

1844: p_consolidation_id NUMBER) IS
1845: SELECT act.assignment_id assignment_id,
1846: act.assignment_action_id run_action_id,
1847: act1.assignment_action_id prepaid_action_id
1848: FROM pay_payroll_actions ppa,
1849: pay_payroll_actions appa,
1850: pay_payroll_actions appa2,
1851: pay_assignment_actions act,
1852: pay_assignment_actions act1,

Line 1849: pay_payroll_actions appa,

1845: SELECT act.assignment_id assignment_id,
1846: act.assignment_action_id run_action_id,
1847: act1.assignment_action_id prepaid_action_id
1848: FROM pay_payroll_actions ppa,
1849: pay_payroll_actions appa,
1850: pay_payroll_actions appa2,
1851: pay_assignment_actions act,
1852: pay_assignment_actions act1,
1853: pay_action_interlocks pai,

Line 1850: pay_payroll_actions appa2,

1846: act.assignment_action_id run_action_id,
1847: act1.assignment_action_id prepaid_action_id
1848: FROM pay_payroll_actions ppa,
1849: pay_payroll_actions appa,
1850: pay_payroll_actions appa2,
1851: pay_assignment_actions act,
1852: pay_assignment_actions act1,
1853: pay_action_interlocks pai,
1854: per_all_assignments_f as1

Line 1879: pay_payroll_actions appa3

1875: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
1876: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
1877: FROM pay_action_interlocks pai1,
1878: pay_assignment_actions act2,
1879: pay_payroll_actions appa3
1880: WHERE pai1.locked_action_id = act.assignment_action_id
1881: AND act2.assignment_action_id = pai1.locking_action_id
1882: AND act2.payroll_action_id = appa3.payroll_action_id
1883: AND appa3.action_type = 'X'

Line 1898: FROM pay_payroll_actions ppa,

1894: p_consolidation_id NUMBER) IS
1895: SELECT act.assignment_id assignment_id,
1896: act.assignment_action_id run_action_id,
1897: act1.assignment_action_id prepaid_action_id
1898: FROM pay_payroll_actions ppa,
1899: pay_payroll_actions appa,
1900: pay_payroll_actions appa2,
1901: pay_assignment_actions act,
1902: pay_assignment_actions act1,

Line 1899: pay_payroll_actions appa,

1895: SELECT act.assignment_id assignment_id,
1896: act.assignment_action_id run_action_id,
1897: act1.assignment_action_id prepaid_action_id
1898: FROM pay_payroll_actions ppa,
1899: pay_payroll_actions appa,
1900: pay_payroll_actions appa2,
1901: pay_assignment_actions act,
1902: pay_assignment_actions act1,
1903: pay_action_interlocks pai,

Line 1900: pay_payroll_actions appa2,

1896: act.assignment_action_id run_action_id,
1897: act1.assignment_action_id prepaid_action_id
1898: FROM pay_payroll_actions ppa,
1899: pay_payroll_actions appa,
1900: pay_payroll_actions appa2,
1901: pay_assignment_actions act,
1902: pay_assignment_actions act1,
1903: pay_action_interlocks pai,
1904: per_all_assignments_f as1,

Line 1931: pay_payroll_actions appa3

1927: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
1928: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
1929: FROM pay_action_interlocks pai1,
1930: pay_assignment_actions act2,
1931: pay_payroll_actions appa3
1932: WHERE pai1.locked_action_id = act.assignment_action_id
1933: AND act2.assignment_action_id = pai1.locking_action_id
1934: AND act2.payroll_action_id = appa3.payroll_action_id
1935: AND appa3.action_type = 'X'

Line 2076: pay_payroll_actions paa,

2072: paa.time_period_id time_period_id,
2073: paa.action_type action_type /*Added for the bug 7502055*/
2074: FROM pay_action_interlocks pre,
2075: pay_action_interlocks pay,
2076: pay_payroll_actions paa,
2077: pay_payroll_actions ppaa,
2078: pay_assignment_actions assact,
2079: pay_assignment_actions passact
2080: WHERE pre.locked_action_id = pay.locking_action_id

Line 2077: pay_payroll_actions ppaa,

2073: paa.action_type action_type /*Added for the bug 7502055*/
2074: FROM pay_action_interlocks pre,
2075: pay_action_interlocks pay,
2076: pay_payroll_actions paa,
2077: pay_payroll_actions ppaa,
2078: pay_assignment_actions assact,
2079: pay_assignment_actions passact
2080: WHERE pre.locked_action_id = pay.locking_action_id
2081: AND pre.locking_action_id = p_locking_action_id

Line 2453: pay_payroll_actions pact,

2449: ppf.payroll_name payroll_name,
2450: ppf.period_type period_type,
2451: pact.pay_advice_message payroll_message
2452: FROM pay_payrolls_f ppf,
2453: pay_payroll_actions pact,
2454: hr_soft_coding_keyflex flex,
2455: hr_organization_information org
2456: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
2457: AND org.org_information_context = 'Tax Details References'

Line 2484: pay_payroll_actions pact

2480: pact.effective_date effective_date,
2481: pact.date_earned date_earned,
2482: pact.pay_advice_message payroll_message
2483: FROM pay_payrolls_f ppf,
2484: pay_payroll_actions pact
2485: WHERE pact.payroll_id = ppf.payroll_id
2486: AND pact.effective_date BETWEEN
2487: ppf.effective_start_date AND ppf.effective_end_date
2488: AND pact.payroll_id = p_payroll_id

Line 2678: pay_payroll_actions ppa, -- prepayment

2674: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) numeric_value
2675: FROM pay_action_interlocks lck, -- archive action locking prepayment
2676: pay_assignment_actions paa1, -- prepayment action
2677: pay_assignment_actions paa2, -- archive action
2678: pay_payroll_actions ppa, -- prepayment
2679: pay_action_information pai, -- archived element/input value definition
2680: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2681: pay_assignment_actions paa, -- payroll run/quickpay action
2682: pay_payroll_actions ppa1, -- payroll run/quickpay action

Line 2682: pay_payroll_actions ppa1, -- payroll run/quickpay action

2678: pay_payroll_actions ppa, -- prepayment
2679: pay_action_information pai, -- archived element/input value definition
2680: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2681: pay_assignment_actions paa, -- payroll run/quickpay action
2682: pay_payroll_actions ppa1, -- payroll run/quickpay action
2683: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2684: pay_input_values_f piv, -- "Pay values" of type Money
2685: pay_run_results prr, -- run result created by the payroll run/quick pay
2686: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay

Line 2729: from pay_payroll_actions ppa,

2725: if (p_assignment_id is null or p_effective_date is null)
2726: then
2727: select paa.assignment_id, ppa.effective_date
2728: into l_assignment_id, l_effective_date
2729: from pay_payroll_actions ppa,
2730: pay_assignment_actions paa
2731: where paa.assignment_action_id = p_assignment_action_id
2732: and paa.payroll_action_id = ppa.payroll_action_id;
2733: