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 606: from pay_payroll_actions ppa,

602: --
603: /* Get the earliest start date on the payroll actions */
604: select min(ppa.start_date)
605: into l_start_date
606: from pay_payroll_actions ppa,
607: pay_assignment_actions paa_ret,
608: pay_assignment_actions paa_mret
609: where ppa.effective_date between p_start_date
610: and p_effective_date

Line 627: pay_payroll_actions ppa,

623: --
624: select min(pra.reprocess_date)
625: into l_reprocess_start_date
626: from pay_retro_assignments pra,
627: 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 1120: pay_payroll_actions ppa

1116: select paa.assignment_action_id,
1117: paa.object_id process_group_id,
1118: ppa.effective_date
1119: from pay_assignment_actions paa,
1120: pay_payroll_actions ppa
1121: where paa.payroll_action_id = p_pactid
1122: and ppa.payroll_action_id = p_pactid
1123: and paa.source_action_id is null
1124: and paa.chunk_number = p_chunk_number;

Line 1200: pay_payroll_actions ppa

1196: select paa2.assignment_id
1197: into l_assignment
1198: from pay_assignment_actions paa2,
1199: per_all_assignments_f paf,
1200: pay_payroll_actions ppa
1201: where p_obj_grp_id = paa2.object_id
1202: and p_obj_type = paa2.object_type
1203: and p_pactid = paa2.payroll_action_id
1204: and ppa.payroll_action_id = p_pactid

Line 1550: pay_payroll_actions ppa,

1546: pay_input_values_f piv1,
1547: pay_run_results prr,
1548: pay_entry_process_details pepd,
1549: pay_assignment_actions paa,
1550: pay_payroll_actions ppa,
1551: pay_retro_components prc,
1552: pay_retro_defn_components prdc2,
1553: pay_retro_defn_components prdc
1554: where paa.assignment_action_id = p_asg_act_id

Line 1585: l_pactid pay_payroll_actions.payroll_action_id%type;

1581: AND prdc2.retro_component_id (+) = p_component_id
1582: AND prdc2.retro_definition_id (+) = p_definition_id
1583: AND nvl(prdc.priority, 99) <= nvl(prdc2.priority, 99);
1584: --
1585: l_pactid pay_payroll_actions.payroll_action_id%type;
1586: l_business_group_id pay_payroll_actions.business_group_id%type;
1587: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1588: l_payroll_id pay_payroll_actions.payroll_id%type;
1589: l_effective_date pay_payroll_actions.effective_date%type;

Line 1586: l_business_group_id pay_payroll_actions.business_group_id%type;

1582: AND prdc2.retro_definition_id (+) = p_definition_id
1583: AND nvl(prdc.priority, 99) <= nvl(prdc2.priority, 99);
1584: --
1585: l_pactid pay_payroll_actions.payroll_action_id%type;
1586: l_business_group_id pay_payroll_actions.business_group_id%type;
1587: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1588: l_payroll_id pay_payroll_actions.payroll_id%type;
1589: l_effective_date pay_payroll_actions.effective_date%type;
1590: l_date_earned pay_payroll_actions.date_earned%type;

Line 1587: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;

1583: AND nvl(prdc.priority, 99) <= nvl(prdc2.priority, 99);
1584: --
1585: l_pactid pay_payroll_actions.payroll_action_id%type;
1586: l_business_group_id pay_payroll_actions.business_group_id%type;
1587: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1588: l_payroll_id pay_payroll_actions.payroll_id%type;
1589: l_effective_date pay_payroll_actions.effective_date%type;
1590: l_date_earned pay_payroll_actions.date_earned%type;
1591: l_time_period_id pay_payroll_actions.time_period_id%type;

Line 1588: l_payroll_id pay_payroll_actions.payroll_id%type;

1584: --
1585: l_pactid pay_payroll_actions.payroll_action_id%type;
1586: l_business_group_id pay_payroll_actions.business_group_id%type;
1587: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1588: l_payroll_id pay_payroll_actions.payroll_id%type;
1589: l_effective_date pay_payroll_actions.effective_date%type;
1590: l_date_earned pay_payroll_actions.date_earned%type;
1591: l_time_period_id pay_payroll_actions.time_period_id%type;
1592: legcode per_business_groups.legislation_code%type;

Line 1589: l_effective_date pay_payroll_actions.effective_date%type;

1585: l_pactid pay_payroll_actions.payroll_action_id%type;
1586: l_business_group_id pay_payroll_actions.business_group_id%type;
1587: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1588: l_payroll_id pay_payroll_actions.payroll_id%type;
1589: l_effective_date pay_payroll_actions.effective_date%type;
1590: l_date_earned pay_payroll_actions.date_earned%type;
1591: l_time_period_id pay_payroll_actions.time_period_id%type;
1592: legcode per_business_groups.legislation_code%type;
1593: l_jc_name varchar2(40);

Line 1590: l_date_earned pay_payroll_actions.date_earned%type;

1586: l_business_group_id pay_payroll_actions.business_group_id%type;
1587: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1588: l_payroll_id pay_payroll_actions.payroll_id%type;
1589: l_effective_date pay_payroll_actions.effective_date%type;
1590: l_date_earned pay_payroll_actions.date_earned%type;
1591: l_time_period_id pay_payroll_actions.time_period_id%type;
1592: legcode per_business_groups.legislation_code%type;
1593: l_jc_name varchar2(40);
1594: l_rule_mode varchar2(40);

Line 1591: l_time_period_id pay_payroll_actions.time_period_id%type;

1587: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%type;
1588: l_payroll_id pay_payroll_actions.payroll_id%type;
1589: l_effective_date pay_payroll_actions.effective_date%type;
1590: l_date_earned pay_payroll_actions.date_earned%type;
1591: l_time_period_id pay_payroll_actions.time_period_id%type;
1592: legcode per_business_groups.legislation_code%type;
1593: l_jc_name varchar2(40);
1594: l_rule_mode varchar2(40);
1595: l_status varchar2(40);

Line 1608: select pay_payroll_actions_s.nextval,

1604: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
1605: --
1606: begin
1607:
1608: select pay_payroll_actions_s.nextval,
1609: ppa.business_group_id,
1610: ppa.consolidation_set_id,
1611: ppa.payroll_id,
1612: ppa.effective_date,

Line 1624: from pay_payroll_actions ppa,

1620: l_effective_date,
1621: l_date_earned,
1622: l_time_period_id,
1623: legcode
1624: from pay_payroll_actions ppa,
1625: pay_assignment_actions paa,
1626: per_business_groups pbg
1627: where ppa.payroll_action_id = paa.payroll_action_id
1628: and pbg.business_group_id = ppa.business_group_id

Line 1631: insert into pay_payroll_actions(

1627: where ppa.payroll_action_id = paa.payroll_action_id
1628: and pbg.business_group_id = ppa.business_group_id
1629: and paa.assignment_action_id = p_asg_act_id;
1630: --
1631: insert into pay_payroll_actions(
1632: payroll_action_id,
1633: action_type,
1634: business_group_id,
1635: consolidation_set_id,