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_ENROLL_PENSION dependencies on PAY_ASSIGNMENT_ACTIONS

Line 180: PAY_ASSIGNMENT_ACTIONS PAA,

176: ptp.end_date DATE_EARNED,
177: ptp.TIME_PERIOD_ID,
178: ptp.PAYROLL_ID
179: FROM PAY_PAYROLL_ACTIONS PPA,
180: PAY_ASSIGNMENT_ACTIONS PAA,
181: PER_TIME_PERIODS PTP
182: WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
183: AND REGULAR_PAYMENT_DATE = PPA.EFFECTIVE_DATE
184: AND ptp.TIME_PERIOD_ID = PPA.TIME_PERIOD_ID

Line 873: PAY_ASSIGNMENT_ACTIONS PAA

869: IS
870: SELECT PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID ,
871: PPA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
872: FROM PAY_PAYROLL_ACTIONS PPA,
873: PAY_ASSIGNMENT_ACTIONS PAA
874: WHERE PPA.ACTION_TYPE IN ('Q','R')
875: AND PAA.ACTION_STATUS = 'C'
876: AND PPA.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
877: AND PAA.ASSIGNMENT_ID = P_ASSIGNMENT_ID

Line 1155: PAY_ASSIGNMENT_ACTIONS PAA,

1151: ptp.TIME_PERIOD_ID,
1152: ptp.PAYROLL_ID,
1153: PRT.RUN_TYPE_NAME
1154: FROM PAY_PAYROLL_ACTIONS PPA,
1155: PAY_ASSIGNMENT_ACTIONS PAA,
1156: PAY_RUN_TYPES_F PRT,
1157: PER_TIME_PERIODS PTP
1158: WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
1159: AND REGULAR_PAYMENT_DATE = PPA.EFFECTIVE_DATE

Line 1184: pay_assignment_actions paa,

1180: WHERE petf.element_type_id = peef.element_type_id
1181: AND peef.element_type_id NOT IN
1182: (SELECT DISTINCT prr.ELEMENT_TYPE_ID
1183: FROM pay_run_results prr,
1184: pay_assignment_actions paa,
1185: pay_payroll_actions ppa
1186: WHERE paa.assignment_action_id = prr.assignment_action_id
1187: AND paa.payroll_action_id = ppa.payroll_action_id
1188: AND ppa.time_period_id = P_TIME_PERIOD_ID

Line 1296: pay_assignment_actions paa ,

1292: AND regular_payment_date BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE
1293: AND regular_payment_date NOT IN
1294: (SELECT effective_date
1295: FROM pay_payroll_actions ppa ,
1296: pay_assignment_actions paa ,
1297: per_time_periods ptp
1298: WHERE ppa.action_type IN ('Q', 'R')
1299: AND ppa.payroll_action_id = paa.payroll_action_id
1300: AND paa.assignment_id = p_assignment_id

Line 1706: , pay_assignment_actions paa

1702: CURSOR c_payroll_run
1703: (p_assignment_id IN number) IS
1704: SELECT ppa.payroll_action_id
1705: FROM pay_payroll_actions ppa
1706: , pay_assignment_actions paa
1707: WHERE ppa.time_period_id = nvl (g_time_period_id, ppa.time_period_id)
1708: AND paa.assignment_id = p_assignment_id
1709: AND ppa.effective_date
1710: BETWEEN g_prp_start_date

Line 3096: pay_assignment_actions paa

3092: IS
3093: SELECT DISTINCT paa.assignment_action_id asg_action_id,
3094: assignment_id
3095: FROM pay_payroll_actions ppa,
3096: pay_assignment_actions paa
3097: WHERE ppa.payroll_action_id = G_PAYROLL_ACTION_ID -- pact_id
3098: AND paa.payroll_action_id = ppa.payroll_action_id
3099: AND paa.action_status = 'C'
3100: --Bug 14492289 - Reporting EJH in separate Sections

Line 3117: pay_assignment_actions paa

3113: IS
3114: SELECT DISTINCT paa.assignment_action_id asg_action_id,
3115: assignment_id
3116: FROM pay_payroll_actions ppa,
3117: pay_assignment_actions paa
3118: WHERE ppa.payroll_action_id = G_PAYROLL_ACTION_ID -- pact_id
3119: AND paa.payroll_action_id = ppa.payroll_action_id
3120: AND
3121: --Bug 14492289 - Reporting EJH in separate Sections

Line 3446: SELECT pay_assignment_actions_s.nextval INTO l_ass_act_id FROM dual;

3442: --- Moved to Arch Init*/
3443: FOR ASG_REC IN C_ALL_ASSIGNMENTS_PAYROLL
3444: LOOP
3445: hr_utility.set_location('Creating assignment action for ' || asg_rec.assignment_id,30);
3446: SELECT pay_assignment_actions_s.nextval INTO l_ass_act_id FROM dual;
3447: --
3448: -- insert into pay_assignment_actions.
3449: hr_nonrun_asact.insact(l_ass_act_id, asg_rec.assignment_id, pactid, chunk, NULL);
3450: END LOOP;

Line 3448: -- insert into pay_assignment_actions.

3444: LOOP
3445: hr_utility.set_location('Creating assignment action for ' || asg_rec.assignment_id,30);
3446: SELECT pay_assignment_actions_s.nextval INTO l_ass_act_id FROM dual;
3447: --
3448: -- insert into pay_assignment_actions.
3449: hr_nonrun_asact.insact(l_ass_act_id, asg_rec.assignment_id, pactid, chunk, NULL);
3450: END LOOP;
3451: EXCEPTION
3452: /*

Line 3581: pay_assignment_actions paa ,

3577: AND regular_payment_date BETWEEN L_PRP_START_DATE AND L_PRP_END_DATE
3578: AND regular_payment_date NOT IN
3579: (SELECT effective_date
3580: FROM pay_payroll_actions ppa ,
3581: pay_assignment_actions paa ,
3582: per_time_periods ptp
3583: WHERE ppa.action_type IN ('Q', 'R')
3584: AND ppa.payroll_action_id = paa.payroll_action_id
3585: AND paa.assignment_id = p_assignment_id

Line 4006: PAY_ASSIGNMENT_ACTIONS PAA

4002: PEEF.ELEMENT_ENTRY_ID ,
4003: PAAF.ASSIGNMENT_NUMBER
4004: FROM PER_ALL_ASSIGNMENTS_F PAAF ,
4005: PAY_ELEMENT_ENTRIES_F PEEF,
4006: PAY_ASSIGNMENT_ACTIONS PAA
4007: WHERE PAAF.PAYROLL_ID = G_PAYROLL_ID
4008: AND PAAF.ASSIGNMENT_ID = PEEF.ASSIGNMENT_ID
4009: AND PAAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
4010: AND PEEF.ELEMENT_TYPE_ID = G_ELEMENT_DETAILS.G_ELEMENT_TYPE_ID