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.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 56: from pay_assignment_actions paa,

52: New Cursor uses the latest sequenced payroll action performed on the assignment
53: */
54: cursor csr_last_dt is
55: Select NVL( tp.end_date, p_start_date )
56: from pay_assignment_actions paa,
57: per_all_assignments_f paf,
58: pay_payroll_actions ppa,
59: pay_action_classifications pac,
60: per_time_periods tp

Line 786: PAY_ASSIGNMENT_ACTIONS AAC

782: (
783: Select tp.start_date, tp.end_date, aac.assignment_action_id
784: From per_time_periods tp,
785: pay_payroll_actions ppa,
786: PAY_ASSIGNMENT_ACTIONS AAC
787: Where tp.payroll_id=p_payroll_id
788: AND (tp.start_date <= p_actuals_end_date and tp.end_date >= p_actuals_start_date)
789: and tp.payroll_id = ppa.payroll_id
790: and ppa.payroll_id = p_payroll_id

Line 824: PAY_ASSIGNMENT_ACTIONS AAC

820: (
821: Select tp.start_date, tp.end_date, aac.assignment_action_id
822: From per_time_periods tp,
823: pay_payroll_actions ppa,
824: PAY_ASSIGNMENT_ACTIONS AAC
825: Where tp.payroll_id=p_payroll_id
826: AND (tp.start_date <= p_actuals_end_date and tp.end_date >= p_actuals_start_date)
827: and tp.payroll_id = ppa.payroll_id
828: and ppa.payroll_id = p_payroll_id

Line 866: from pay_assignment_actions

862: select 1
863: from dual
864: where exists
865: (select null
866: from pay_assignment_actions
867: where assignment_id = p_assignment_id);
868:
869: Begin
870: hr_utility.set_location('Entering :'||l_proc,5);

Line 933: PAY_ASSIGNMENT_ACTIONS AAC

929: (
930: Select tp.start_date, tp.end_date, aac.assignment_action_id
931: From per_time_periods tp,
932: pay_payroll_actions ppa,
933: PAY_ASSIGNMENT_ACTIONS AAC
934: Where tp.payroll_id=p_payroll_id
935: AND (tp.start_date <= p_actuals_end_date and tp.end_date >= p_actuals_start_date)
936: and tp.payroll_id = ppa.payroll_id
937: and ppa.payroll_id = p_payroll_id

Line 972: from pay_assignment_actions

968: select 1
969: from dual
970: where exists
971: (select null
972: from pay_assignment_actions
973: where assignment_id = p_assignment_id);
974:
975: Begin
976: hr_utility.set_location('Entering :'||l_proc,5);

Line 1019: PAY_ASSIGNMENT_ACTIONS AAC

1015: Cursor csr_pay_date Is
1016: Select max(tp.end_date)
1017: From per_time_periods tp,
1018: pay_payroll_actions ppa,
1019: PAY_ASSIGNMENT_ACTIONS AAC
1020: Where tp.payroll_id=p_payroll_id
1021: and (tp.start_date <= p_actuals_end_date and tp.end_date >= p_actuals_start_date)
1022: and tp.payroll_id = ppa.payroll_id
1023: and ppa.payroll_id = p_payroll_id

Line 1037: from pay_assignment_actions

1033: select 1
1034: from dual
1035: where exists
1036: (select null
1037: from pay_assignment_actions
1038: where assignment_id = p_assignment_id);
1039:
1040: Begin
1041: hr_utility.set_location('Entering :'||l_proc,5);

Line 1113: from pay_assignment_actions paa, pay_payroll_actions ppa

1109: -- and RUN_BALANCE_STATUS = 'V';
1110:
1111: cursor csr_asg_action(c_assignment_id number, c_effective_date date) is
1112: select paa.assignment_action_id
1113: from pay_assignment_actions paa, pay_payroll_actions ppa
1114: where paa.payroll_action_id = ppa.payroll_action_id
1115: and paa.source_action_id is null
1116: and paa.assignment_id = c_assignment_id
1117: and ppa.effective_date = (select max(effective_date) from pay_payroll_actions ppa1

Line 1124: from pay_run_balances prb, pay_assignment_actions paa

1120: and ppa.effective_date <= c_effective_date);
1121:
1122: cursor csr_act_value(c_assignment_id number,c_defined_balance_id number,c_effective_date date) is
1123: select prb.balance_value
1124: from pay_run_balances prb, pay_assignment_actions paa
1125: where prb.assignment_id = c_assignment_id
1126: and prb.defined_balance_id = c_defined_balance_id
1127: and prb.assignment_action_id = paa.assignment_action_id
1128: and paa.source_action_id is not null

Line 1327: PAY_ASSIGNMENT_ACTIONS AAC

1323: Select /*+ ORDERED */
1324: tp.start_date,tp.end_date, aac.assignment_action_id
1325: From per_time_periods tp,
1326: pay_payroll_actions ppa,
1327: PAY_ASSIGNMENT_ACTIONS AAC
1328: Where tp.payroll_id=p_payroll_id
1329: AND (tp.start_date <= p_actuals_end_date
1330: and
1331: tp.end_date >= p_actuals_start_date)

Line 1361: from pay_assignment_actions

1357: select 1
1358: from dual
1359: where exists
1360: (select null
1361: from pay_assignment_actions
1362: where assignment_id = p_assignment_id);
1363: Begin
1364: --
1365: hr_utility.set_location('Entering :'||l_proc,5);

Line 4072: PAY_ASSIGNMENT_ACTIONS AAC,

4068: AND assg.position_id = p_position_id
4069: -- and assg.assignment_id <> p_ex_assignment_id
4070: ) a,
4071: pay_payroll_actions ppa,
4072: PAY_ASSIGNMENT_ACTIONS AAC,
4073: PAY_COSTS pc,
4074: PAY_ELEMENT_TYPES_F PET,
4075: PAY_INPUT_VALUES_F INV,
4076: pqh_bdgt_cmmtmnt_elmnts pbce

Line 4128: PAY_ASSIGNMENT_ACTIONS AAC,

4124: AND assg.position_id = p_position_id
4125: -- and assg.assignment_id <> p_ex_assignment_id
4126: ) a,
4127: pay_payroll_actions ppa,
4128: PAY_ASSIGNMENT_ACTIONS AAC,
4129: PAY_COSTS pc,
4130: PAY_ELEMENT_TYPES_F PET,
4131: PAY_INPUT_VALUES_F INV
4132: Where PPA.PAYROLL_ACTION_ID = AAC.PAYROLL_ACTION_ID