[Home] [Help]
1941: ptp.period_num,
1942: ptp.period_type
1943: FROM pay_payroll_actions ppa,
1944: pay_assignment_actions paa,
1945: per_time_periods ptp
1946: WHERE assignment_action_id = p_last_asg_action_id
1947: AND ppa.time_period_id = ptp.time_period_id
1948: AND ppa.payroll_id = ptp.payroll_id
1949: AND paa.payroll_action_id = ppa.payroll_action_id;
2040: MIN(ptp.start_date) payroll_period_start_date,
2041: MAX(ptp.end_date) payroll_period_end_date
2042: FROM pay_assignment_actions paa,
2043: pay_payroll_actions pact,
2044: per_time_periods ptp,
2045: pay_assignment_actions paa1, --Prepayments
2046: pay_payroll_actions ppa1, --Prepayments
2047: pay_action_interlocks pai --Prepayments
2048: WHERE paa.assignment_id = p_asgid
2727: ptp.period_num,
2728: ptp.period_type
2729: FROM pay_payroll_actions ppa,
2730: pay_assignment_actions paa,
2731: per_time_periods ptp
2732: WHERE assignment_action_id = l_last_asg_action_id
2733: AND ppa.time_period_id = ptp.time_period_id
2734: AND ppa.payroll_id = ptp.payroll_id
2735: AND paa.payroll_action_id = ppa.payroll_action_id;
2816: MIN(ptp.start_date) payroll_period_start_date,
2817: MAX(ptp.end_date) payroll_period_end_date
2818: FROM pay_assignment_actions paa,
2819: pay_payroll_actions pact,
2820: per_time_periods ptp,
2821: pay_assignment_actions paa1, --Prepayments
2822: pay_payroll_actions ppa1, --Prepayments
2823: pay_action_interlocks pai --Prepayments
2824: WHERE paa.assignment_id = p_asgid
2927: MAX(pact.effective_date) effective_date
2928: FROM per_all_assignments_f paaf,
2929: pay_assignment_actions paa,
2930: pay_payroll_actions pact,
2931: per_time_periods ptp,
2932: pay_assignment_actions paa1, --Prepayments
2933: pay_payroll_actions ppa1, --Prepayments
2934: pay_action_interlocks pai --Prepayments
2935: WHERE paaf.person_id = p_person_rec.person_id--59437
3529: ptp.period_num,
3530: ptp.period_type
3531: FROM pay_payroll_actions ppa,
3532: pay_assignment_actions paa,
3533: per_time_periods ptp
3534: WHERE assignment_action_id = p_last_asg_action_id
3535: AND ppa.time_period_id = ptp.time_period_id
3536: AND ppa.payroll_id = ptp.payroll_id
3537: AND paa.payroll_action_id = ppa.payroll_action_id;
3619: MIN(ptp.start_date) payroll_period_start_date,
3620: MAX(ptp.end_date) payroll_period_end_date
3621: FROM pay_assignment_actions paa,
3622: pay_payroll_actions pact,
3623: per_time_periods ptp,
3624: pay_assignment_actions paa1, --Prepayments
3625: pay_payroll_actions ppa1, --Prepayments
3626: pay_action_interlocks pai --Prepayments
3627: WHERE paa.assignment_id = p_asgid
6971: || paa.assignment_action_id), 16))
6972: , max (pact.effective_date) effective_date
6973: FROM pay_assignment_actions paa
6974: , pay_payroll_actions pact
6975: , per_time_periods ptp
6976: WHERE paa.assignment_id = p_asgid
6977: AND paa.payroll_action_id = pact.payroll_action_id
6978: AND pact.payroll_id = l_payroll_id
6979: AND pact.time_period_id = ptp.time_period_id
7075: ,pay_assignment_actions paa1
7076: ,per_all_assignments_f paaf
7077: ,pay_payroll_actions pact
7078: ,pay_payroll_actions pact1
7079: ,per_time_periods ptp
7080: ,pay_action_interlocks pai
7081: WHERE paa.assignment_id = paaf.assignment_id
7082: AND paa.assignment_id <> p_asg_id
7083: AND paaf.person_id = p_person_id
7133: ,pay_assignment_actions paa1
7134: ,per_all_assignments_f paaf
7135: ,pay_payroll_actions pact
7136: ,pay_payroll_actions pact1
7137: ,per_time_periods ptp
7138: ,pay_action_interlocks pai
7139: WHERE paa.assignment_id = paaf.assignment_id
7140: AND paa.assignment_id = p_asg_id
7141: AND paaf.person_id = p_person_id
7266: SELECT count(distinct paa1.assignment_id)
7267: FROM pay_assignment_actions paa,
7268: per_all_assignments_f paaf,
7269: pay_payroll_actions pact,
7270: per_time_periods ptp,
7271: pay_assignment_actions paa1, --Prepayments
7272: pay_payroll_actions ppa1, --Prepayments
7273: pay_action_interlocks pai --Prepayments
7274: WHERE paa.assignment_id = paaf.assignment_id
8582: , max(pact.effective_date) effective_date
8583:
8584: FROM pay_assignment_actions paa
8585: ,pay_payroll_actions pact
8586: ,per_time_periods ptp
8587: WHERE paa.assignment_id = c_asg_id
8588: AND paa.payroll_action_id = pact.payroll_action_id
8589: AND pact.time_period_id = ptp.time_period_id
8590: AND pact.action_type IN ('Q','R','B','I','V')
8601: , max(pact.effective_date) effective_date
8602:
8603: FROM pay_assignment_actions paa
8604: ,pay_payroll_actions pact
8605: ,per_time_periods ptp
8606: WHERE paa.assignment_id = c_asg_id
8607: AND paa.payroll_action_id = pact.payroll_action_id
8608: AND pact.time_period_id = ptp.time_period_id
8609: AND pact.action_type IN ('Q','R','B','I','V')
8768: IS
8769: SELECT ptp.regular_payment_date payment_date
8770: FROM pay_payroll_actions ppa,
8771: pay_assignment_actions paa,
8772: per_time_periods ptp
8773: WHERE assignment_action_id = p_last_asg_action_id
8774: AND ppa.time_period_id = ptp.time_period_id
8775: AND ppa.payroll_id = ptp.payroll_id
8776: AND paa.payroll_action_id = ppa.payroll_action_id;
8834: || paa.assignment_action_id),16)) max_asg_act_id,
8835: MAX(pact.effective_date) effective_date
8836: FROM pay_assignment_actions paa,
8837: pay_payroll_actions pact,
8838: per_time_periods ptp,
8839: pay_assignment_actions paa1, --Prepayments
8840: pay_payroll_actions ppa1, --Prepayments
8841: pay_action_interlocks pai --Prepayments
8842: WHERE paa.assignment_id = p_asgid
8860: || paa.assignment_action_id),16)) max_asg_act_id,
8861: MAX(pact.effective_date) effective_date
8862: FROM pay_assignment_actions paa,
8863: pay_payroll_actions pact,
8864: per_time_periods ptp,
8865: pay_assignment_actions paa1, --Prepayments
8866: pay_payroll_actions ppa1, --Prepayments
8867: pay_action_interlocks pai --Prepayments
8868: WHERE paa.assignment_id = p_asgid --46959
9009: MAX(pact.effective_date) effective_date
9010: FROM pay_assignment_actions paa,
9011: per_all_assignments_f paaf,
9012: pay_payroll_actions pact,
9013: per_time_periods ptp,
9014: pay_assignment_actions paa1, --Prepayments
9015: pay_payroll_actions ppa1, --Prepayments
9016: pay_action_interlocks pai --Prepayments
9017: WHERE paa.assignment_id = paaf.assignment_id
9050: ,max (pact.effective_date) effective_date
9051: FROM pay_assignment_actions paa
9052: ,per_all_assignments_f paaf
9053: ,pay_payroll_actions pact
9054: ,per_time_periods ptp
9055: WHERE paa.assignment_id = paaf.assignment_id
9056: AND paaf.person_id = p_person_id
9057: AND paa.payroll_action_id = pact.payroll_action_id
9058: AND pact.time_period_id = ptp.time_period_id
9271: || paa.assignment_action_id), 16))
9272: , max (pact.effective_date) effective_date
9273: FROM pay_assignment_actions paa
9274: , pay_payroll_actions pact
9275: , per_time_periods ptp
9276: WHERE paa.assignment_id = p_asgid
9277: AND paa.payroll_action_id = pact.payroll_action_id
9278: AND pact.payroll_id = l_payroll
9279: AND pact.time_period_id = ptp.time_period_id
9294: || paa.assignment_action_id), 16))
9295: , max (pact.effective_date) effective_date
9296: FROM pay_assignment_actions paa
9297: , pay_payroll_actions pact
9298: , per_time_periods ptp
9299: WHERE paa.assignment_id = p_asgid
9300: AND paa.payroll_action_id = pact.payroll_action_id
9301: AND pact.time_period_id = ptp.time_period_id
9302: AND pact.action_type IN ('Q', 'R', 'B'
9669: , max(pact.effective_date) effective_date
9670:
9671: FROM pay_assignment_actions paa
9672: ,pay_payroll_actions pact
9673: ,per_time_periods ptp
9674: WHERE paa.assignment_id = c_asg_id
9675: AND paa.payroll_action_id = pact.payroll_action_id
9676: AND pact.time_period_id = ptp.time_period_id
9677: AND pact.action_type IN ('Q','R','B','I','V')
9692: SELECT count(distinct paa1.assignment_id)
9693: FROM pay_assignment_actions paa,
9694: per_all_assignments_f paaf,
9695: pay_payroll_actions pact,
9696: per_time_periods ptp,
9697: pay_assignment_actions paa1, --Prepayments
9698: pay_payroll_actions ppa1, --Prepayments
9699: pay_action_interlocks pai --Prepayments
9700: WHERE paa.assignment_id = paaf.assignment_id
9729:
9730: FROM per_all_assignments_f paaf,
9731: pay_assignment_actions paa
9732: , pay_payroll_actions pact
9733: , per_time_periods ptp
9734: WHERE paa.assignment_id = paaf.assignment_id
9735: and paaf.person_id = person_id
9736: AND paa.payroll_action_id = pact.payroll_action_id
9737: AND pact.time_period_id = ptp.time_period_id