[Home] [Help]
1431: ptp.period_num,
1432: ptp.period_type
1433: FROM pay_payroll_actions ppa,
1434: pay_assignment_actions paa,
1435: per_time_periods ptp
1436: WHERE assignment_action_id = p_last_asg_action_id
1437: AND ppa.time_period_id = ptp.time_period_id
1438: AND ppa.payroll_id = ptp.payroll_id
1439: AND paa.payroll_action_id = ppa.payroll_action_id;
1530: MIN(ptp.start_date) payroll_period_start_date,
1531: MAX(ptp.end_date) payroll_period_end_date
1532: FROM pay_assignment_actions paa,
1533: pay_payroll_actions pact,
1534: per_time_periods ptp,
1535: pay_assignment_actions paa1, --Prepayments
1536: pay_payroll_actions ppa1, --Prepayments
1537: pay_action_interlocks pai --Prepayments
1538: WHERE paa.assignment_id = p_asgid
2249: ptp.period_num,
2250: ptp.period_type
2251: FROM pay_payroll_actions ppa,
2252: pay_assignment_actions paa,
2253: per_time_periods ptp
2254: WHERE assignment_action_id = l_last_asg_action_id
2255: AND ppa.time_period_id = ptp.time_period_id
2256: AND ppa.payroll_id = ptp.payroll_id
2257: AND paa.payroll_action_id = ppa.payroll_action_id;
2338: MIN(ptp.start_date) payroll_period_start_date,
2339: MAX(ptp.end_date) payroll_period_end_date
2340: FROM pay_assignment_actions paa,
2341: pay_payroll_actions pact,
2342: per_time_periods ptp,
2343: pay_assignment_actions paa1, --Prepayments
2344: pay_payroll_actions ppa1, --Prepayments
2345: pay_action_interlocks pai --Prepayments
2346: WHERE paa.assignment_id = p_asgid
2454: MAX(pact.effective_date) effective_date
2455: FROM per_all_assignments_f paaf,
2456: pay_assignment_actions paa,
2457: pay_payroll_actions pact,
2458: per_time_periods ptp,
2459: pay_assignment_actions paa1, --Prepayments
2460: pay_payroll_actions ppa1, --Prepayments
2461: pay_action_interlocks pai --Prepayments
2462: WHERE paaf.person_id = p_person_rec.person_id--59437
3062: ptp.period_num,
3063: ptp.period_type
3064: FROM pay_payroll_actions ppa,
3065: pay_assignment_actions paa,
3066: per_time_periods ptp
3067: WHERE assignment_action_id = p_last_asg_action_id
3068: AND ppa.time_period_id = ptp.time_period_id
3069: AND ppa.payroll_id = ptp.payroll_id
3070: AND paa.payroll_action_id = ppa.payroll_action_id;
3152: MIN(ptp.start_date) payroll_period_start_date,
3153: MAX(ptp.end_date) payroll_period_end_date
3154: FROM pay_assignment_actions paa,
3155: pay_payroll_actions pact,
3156: per_time_periods ptp,
3157: pay_assignment_actions paa1, --Prepayments
3158: pay_payroll_actions ppa1, --Prepayments
3159: pay_action_interlocks pai --Prepayments
3160: WHERE paa.assignment_id = p_asgid
6302: || paa.assignment_action_id), 16))
6303: , max (pact.effective_date) effective_date
6304: FROM pay_assignment_actions paa
6305: , pay_payroll_actions pact
6306: , per_time_periods ptp
6307: WHERE paa.assignment_id = p_asgid
6308: AND paa.payroll_action_id = pact.payroll_action_id
6309: AND pact.payroll_id = l_payroll_id
6310: AND pact.time_period_id = ptp.time_period_id
6407: ,pay_assignment_actions paa1
6408: ,per_all_assignments_f paaf
6409: ,pay_payroll_actions pact
6410: ,pay_payroll_actions pact1
6411: ,per_time_periods ptp
6412: ,pay_action_interlocks pai
6413: WHERE paa.assignment_id = paaf.assignment_id
6414: AND paa.assignment_id <> p_asg_id
6415: AND paaf.person_id = p_person_id
6465: ,pay_assignment_actions paa1
6466: ,per_all_assignments_f paaf
6467: ,pay_payroll_actions pact
6468: ,pay_payroll_actions pact1
6469: ,per_time_periods ptp
6470: ,pay_action_interlocks pai
6471: WHERE paa.assignment_id = paaf.assignment_id
6472: AND paa.assignment_id = p_asg_id
6473: AND paaf.person_id = p_person_id
6597: SELECT count(distinct paa1.assignment_id)
6598: FROM pay_assignment_actions paa,
6599: per_all_assignments_f paaf,
6600: pay_payroll_actions pact,
6601: per_time_periods ptp,
6602: pay_assignment_actions paa1, --Prepayments
6603: pay_payroll_actions ppa1, --Prepayments
6604: pay_action_interlocks pai --Prepayments
6605: WHERE paa.assignment_id = paaf.assignment_id
7950: , max(pact.effective_date) effective_date
7951:
7952: FROM pay_assignment_actions paa
7953: ,pay_payroll_actions pact
7954: ,per_time_periods ptp
7955: WHERE paa.assignment_id = c_asg_id
7956: AND paa.payroll_action_id = pact.payroll_action_id
7957: AND pact.time_period_id = ptp.time_period_id
7958: AND pact.action_type IN ('Q','R','B','I','V')
7969: , max(pact.effective_date) effective_date
7970:
7971: FROM pay_assignment_actions paa
7972: ,pay_payroll_actions pact
7973: ,per_time_periods ptp
7974: WHERE paa.assignment_id = c_asg_id
7975: AND paa.payroll_action_id = pact.payroll_action_id
7976: AND pact.time_period_id = ptp.time_period_id
7977: AND pact.action_type IN ('Q','R','B','I','V')
8134: IS
8135: SELECT ptp.regular_payment_date payment_date
8136: FROM pay_payroll_actions ppa,
8137: pay_assignment_actions paa,
8138: per_time_periods ptp
8139: WHERE assignment_action_id = p_last_asg_action_id
8140: AND ppa.time_period_id = ptp.time_period_id
8141: AND ppa.payroll_id = ptp.payroll_id
8142: AND paa.payroll_action_id = ppa.payroll_action_id;
8200: || paa.assignment_action_id),16)) max_asg_act_id,
8201: MAX(pact.effective_date) effective_date
8202: FROM pay_assignment_actions paa,
8203: pay_payroll_actions pact,
8204: per_time_periods ptp,
8205: pay_assignment_actions paa1, --Prepayments
8206: pay_payroll_actions ppa1, --Prepayments
8207: pay_action_interlocks pai --Prepayments
8208: WHERE paa.assignment_id = p_asgid
8226: || paa.assignment_action_id),16)) max_asg_act_id,
8227: MAX(pact.effective_date) effective_date
8228: FROM pay_assignment_actions paa,
8229: pay_payroll_actions pact,
8230: per_time_periods ptp,
8231: pay_assignment_actions paa1, --Prepayments
8232: pay_payroll_actions ppa1, --Prepayments
8233: pay_action_interlocks pai --Prepayments
8234: WHERE paa.assignment_id = p_asgid --46959
8375: MAX(pact.effective_date) effective_date
8376: FROM pay_assignment_actions paa,
8377: per_all_assignments_f paaf,
8378: pay_payroll_actions pact,
8379: per_time_periods ptp,
8380: pay_assignment_actions paa1, --Prepayments
8381: pay_payroll_actions ppa1, --Prepayments
8382: pay_action_interlocks pai --Prepayments
8383: WHERE paa.assignment_id = paaf.assignment_id
8416: ,max (pact.effective_date) effective_date
8417: FROM pay_assignment_actions paa
8418: ,per_all_assignments_f paaf
8419: ,pay_payroll_actions pact
8420: ,per_time_periods ptp
8421: WHERE paa.assignment_id = paaf.assignment_id
8422: AND paaf.person_id = p_person_id
8423: AND paa.payroll_action_id = pact.payroll_action_id
8424: AND pact.time_period_id = ptp.time_period_id
8635: || paa.assignment_action_id), 16))
8636: , max (pact.effective_date) effective_date
8637: FROM pay_assignment_actions paa
8638: , pay_payroll_actions pact
8639: , per_time_periods ptp
8640: WHERE paa.assignment_id = p_asgid
8641: AND paa.payroll_action_id = pact.payroll_action_id
8642: AND pact.payroll_id = l_payroll
8643: AND pact.time_period_id = ptp.time_period_id
8658: || paa.assignment_action_id), 16))
8659: , max (pact.effective_date) effective_date
8660: FROM pay_assignment_actions paa
8661: , pay_payroll_actions pact
8662: , per_time_periods ptp
8663: WHERE paa.assignment_id = p_asgid
8664: AND paa.payroll_action_id = pact.payroll_action_id
8665: AND pact.time_period_id = ptp.time_period_id
8666: AND pact.action_type IN ('Q', 'R', 'B'
9034: , max(pact.effective_date) effective_date
9035:
9036: FROM pay_assignment_actions paa
9037: ,pay_payroll_actions pact
9038: ,per_time_periods ptp
9039: WHERE paa.assignment_id = c_asg_id
9040: AND paa.payroll_action_id = pact.payroll_action_id
9041: AND pact.time_period_id = ptp.time_period_id
9042: AND pact.action_type IN ('Q','R','B','I','V')
9056: SELECT count(distinct paa1.assignment_id)
9057: FROM pay_assignment_actions paa,
9058: per_all_assignments_f paaf,
9059: pay_payroll_actions pact,
9060: per_time_periods ptp,
9061: pay_assignment_actions paa1, --Prepayments
9062: pay_payroll_actions ppa1, --Prepayments
9063: pay_action_interlocks pai --Prepayments
9064: WHERE paa.assignment_id = paaf.assignment_id
9093:
9094: FROM per_all_assignments_f paaf,
9095: pay_assignment_actions paa
9096: , pay_payroll_actions pact
9097: , per_time_periods ptp
9098: WHERE paa.assignment_id = paaf.assignment_id
9099: and paaf.person_id = person_id
9100: AND paa.payroll_action_id = pact.payroll_action_id
9101: AND pact.time_period_id = ptp.time_period_id