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

Line 627: from pay_payroll_actions ppa,

623: --
624: /* Get the earliest start date on the payroll actions */
625: select min(ppa.start_date)
626: into l_start_date
627: from pay_payroll_actions ppa,
628: pay_assignment_actions paa_ret,
629: pay_assignment_actions paa_mret
630: where ppa.effective_date between p_start_date
631: and p_effective_date

Line 649: pay_payroll_actions ppa,

645:
646: select min(pra.reprocess_date)
647: into l_reprocess_start_date
648: from pay_retro_assignments pra,
649: pay_payroll_actions ppa,
650: pay_assignment_actions paa_ret,
651: pay_assignment_actions paa_mret
652: where ppa.effective_date between p_start_date
653: and p_effective_date

Line 1151: pay_payroll_actions ppa

1147: select paa.assignment_action_id,
1148: paa.object_id process_group_id,
1149: ppa.effective_date
1150: from pay_assignment_actions paa,
1151: pay_payroll_actions ppa
1152: where paa.payroll_action_id = p_pactid
1153: and ppa.payroll_action_id = p_pactid
1154: and paa.source_action_id is null
1155: and paa.chunk_number = p_chunk_number;

Line 1231: pay_payroll_actions ppa

1227: select paa2.assignment_id
1228: into l_assignment
1229: from pay_assignment_actions paa2,
1230: per_all_assignments_f paf,
1231: pay_payroll_actions ppa
1232: where p_obj_grp_id = paa2.object_id
1233: and p_obj_type = paa2.object_type
1234: and p_pactid = paa2.payroll_action_id
1235: and ppa.payroll_action_id = p_pactid

Line 1583: pay_payroll_actions ppa,

1579: pay_input_values_f piv1,
1580: pay_run_results prr,
1581: pay_entry_process_details pepd,
1582: pay_assignment_actions paa,
1583: pay_payroll_actions ppa,
1584: pay_retro_components prc,
1585: pay_retro_defn_components prdc2,
1586: pay_retro_defn_components prdc
1587: where paa.assignment_action_id = p_asg_act_id

Line 1618: l_pactid pay_payroll_actions.payroll_action_id%type;

1614: AND prdc2.retro_component_id (+) = p_component_id
1615: AND prdc2.retro_definition_id (+) = p_definition_id
1616: AND nvl(prdc.priority, 99) <= nvl(prdc2.priority, 99);
1617: --
1618: l_pactid pay_payroll_actions.payroll_action_id%type;
1619: l_business_group_id pay_payroll_actions.business_group_id%type;
1620: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1621: l_payroll_id pay_payroll_actions.payroll_id%type;
1622: l_effective_date pay_payroll_actions.effective_date%type;

Line 1619: l_business_group_id pay_payroll_actions.business_group_id%type;

1615: AND prdc2.retro_definition_id (+) = p_definition_id
1616: AND nvl(prdc.priority, 99) <= nvl(prdc2.priority, 99);
1617: --
1618: l_pactid pay_payroll_actions.payroll_action_id%type;
1619: l_business_group_id pay_payroll_actions.business_group_id%type;
1620: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1621: l_payroll_id pay_payroll_actions.payroll_id%type;
1622: l_effective_date pay_payroll_actions.effective_date%type;
1623: l_date_earned pay_payroll_actions.date_earned%type;

Line 1620: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;

1616: AND nvl(prdc.priority, 99) <= nvl(prdc2.priority, 99);
1617: --
1618: l_pactid pay_payroll_actions.payroll_action_id%type;
1619: l_business_group_id pay_payroll_actions.business_group_id%type;
1620: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1621: l_payroll_id pay_payroll_actions.payroll_id%type;
1622: l_effective_date pay_payroll_actions.effective_date%type;
1623: l_date_earned pay_payroll_actions.date_earned%type;
1624: l_time_period_id pay_payroll_actions.time_period_id%type;

Line 1621: l_payroll_id pay_payroll_actions.payroll_id%type;

1617: --
1618: l_pactid pay_payroll_actions.payroll_action_id%type;
1619: l_business_group_id pay_payroll_actions.business_group_id%type;
1620: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1621: l_payroll_id pay_payroll_actions.payroll_id%type;
1622: l_effective_date pay_payroll_actions.effective_date%type;
1623: l_date_earned pay_payroll_actions.date_earned%type;
1624: l_time_period_id pay_payroll_actions.time_period_id%type;
1625: legcode per_business_groups.legislation_code%type;

Line 1622: l_effective_date pay_payroll_actions.effective_date%type;

1618: l_pactid pay_payroll_actions.payroll_action_id%type;
1619: l_business_group_id pay_payroll_actions.business_group_id%type;
1620: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1621: l_payroll_id pay_payroll_actions.payroll_id%type;
1622: l_effective_date pay_payroll_actions.effective_date%type;
1623: l_date_earned pay_payroll_actions.date_earned%type;
1624: l_time_period_id pay_payroll_actions.time_period_id%type;
1625: legcode per_business_groups.legislation_code%type;
1626: l_jc_name varchar2(40);

Line 1623: l_date_earned pay_payroll_actions.date_earned%type;

1619: l_business_group_id pay_payroll_actions.business_group_id%type;
1620: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1621: l_payroll_id pay_payroll_actions.payroll_id%type;
1622: l_effective_date pay_payroll_actions.effective_date%type;
1623: l_date_earned pay_payroll_actions.date_earned%type;
1624: l_time_period_id pay_payroll_actions.time_period_id%type;
1625: legcode per_business_groups.legislation_code%type;
1626: l_jc_name varchar2(40);
1627: l_rule_mode varchar2(40);

Line 1624: l_time_period_id pay_payroll_actions.time_period_id%type;

1620: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1621: l_payroll_id pay_payroll_actions.payroll_id%type;
1622: l_effective_date pay_payroll_actions.effective_date%type;
1623: l_date_earned pay_payroll_actions.date_earned%type;
1624: l_time_period_id pay_payroll_actions.time_period_id%type;
1625: legcode per_business_groups.legislation_code%type;
1626: l_jc_name varchar2(40);
1627: l_rule_mode varchar2(40);
1628: l_status varchar2(40);

Line 1641: select pay_payroll_actions_s.nextval,

1637: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
1638: --
1639: begin
1640: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',10);
1641: select pay_payroll_actions_s.nextval,
1642: ppa.business_group_id,
1643: ppa.consolidation_set_id,
1644: ppa.payroll_id,
1645: ppa.effective_date,

Line 1657: from pay_payroll_actions ppa,

1653: l_effective_date,
1654: l_date_earned,
1655: l_time_period_id,
1656: legcode
1657: from pay_payroll_actions ppa,
1658: pay_assignment_actions paa,
1659: per_business_groups pbg
1660: where ppa.payroll_action_id = paa.payroll_action_id
1661: and pbg.business_group_id = ppa.business_group_id

Line 1664: insert into pay_payroll_actions(

1660: where ppa.payroll_action_id = paa.payroll_action_id
1661: and pbg.business_group_id = ppa.business_group_id
1662: and paa.assignment_action_id = p_asg_act_id;
1663: --
1664: insert into pay_payroll_actions(
1665: payroll_action_id,
1666: action_type,
1667: business_group_id,
1668: consolidation_set_id,

Line 1761: select pay_payroll_actions_s.nextval

1757: --
1758: if (l_asg_act_id <> -1) then
1759: pay_balance_pkg.maintain_balances_for_action(l_asg_act_id);
1760: -- Bug 8614449 : create a new payroll action
1761: select pay_payroll_actions_s.nextval
1762: into l_pactid
1763: from dual;
1764: --
1765: insert into pay_payroll_actions(

Line 1765: insert into pay_payroll_actions(

1761: select pay_payroll_actions_s.nextval
1762: into l_pactid
1763: from dual;
1764: --
1765: insert into pay_payroll_actions(
1766: payroll_action_id,
1767: action_type,
1768: business_group_id,
1769: consolidation_set_id,

Line 1842: select pay_payroll_actions_s.nextval

1838: /* Bug 8614449 */
1839: if (l_asg_act_id <> -1) then
1840: pay_balance_pkg.maintain_balances_for_action(l_asg_act_id);
1841:
1842: select pay_payroll_actions_s.nextval
1843: into l_pactid
1844: from dual;
1845:
1846: insert into pay_payroll_actions(

Line 1846: insert into pay_payroll_actions(

1842: select pay_payroll_actions_s.nextval
1843: into l_pactid
1844: from dual;
1845:
1846: insert into pay_payroll_actions(
1847: payroll_action_id,
1848: action_type,
1849: business_group_id,
1850: consolidation_set_id,

Line 1889: select pay_payroll_actions_s.nextval

1885: --
1886: if (l_asg_act_id <> -1) then
1887: pay_balance_pkg.maintain_balances_for_action(l_asg_act_id);
1888: -- Bug 8614449 : create a new payroll action
1889: select pay_payroll_actions_s.nextval
1890: into l_pactid
1891: from dual;
1892: --
1893: insert into pay_payroll_actions(

Line 1893: insert into pay_payroll_actions(

1889: select pay_payroll_actions_s.nextval
1890: into l_pactid
1891: from dual;
1892: --
1893: insert into pay_payroll_actions(
1894: payroll_action_id,
1895: action_type,
1896: business_group_id,
1897: consolidation_set_id,