DBA Data[Home] [Help]

APPS.PSB_WS_POS1 dependencies on PSB_PAY_ELEMENTS

Line 63: from PSB_PAY_ELEMENTS

59:
60: cursor c_Rec_Elements (DataExt NUMBER,
61: BusGrp NUMBER) is
62: select pay_element_id
63: from PSB_PAY_ELEMENTS
64: where processing_type = 'R'
65: and business_group_id = BusGrp
66: and data_extract_id = DataExt
67: /* For Bug No. 2250319 */

Line 633: from PSB_PAY_ELEMENTS

629: salary_type,
630: follow_salary,
631: period_type,
632: process_period_type
633: from PSB_PAY_ELEMENTS
634: where (((start_date <= PSB_WS_ACCT1.g_end_est_date)
635: and (end_date is null))
636: or ((start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
637: or (end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)

Line 4138: from PSB_PAY_ELEMENTS b,

4134: a.period57_amount, a.period58_amount, a.period59_amount, a.period60_amount
4135: from PSB_WS_ACCOUNT_LINES a
4136: where exists
4137: (select 1
4138: from PSB_PAY_ELEMENTS b,
4139: PSB_WS_ELEMENT_LINES c
4140: where b.processing_type = 'R'
4141: and b.pay_element_id = c.pay_element_id
4142: and c.element_set_id = a.element_set_id