APPS.PQP_GB_PSI_FUNCTIONS dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 7083: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'

7079: END IF;
7080:
7081: IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7082: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS') OR l_chg_type = 'I'))
7083: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7084: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_chg_type = 'I'))
7085: OR (l_chg_table = 'PAY_ELEMENT_ENTRIES_F'
7086: AND l_chg_type <> 'E')
7087: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F') THEN

Line 7276: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'

7272: l_sal_ele_end_evt_exist := 'Y';
7273:
7274: ELSIF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7275: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS') OR l_update_type = 'I'))
7276: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7277: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_update_type = 'I'))
7278: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F') THEN
7279:
7280: l_other_event_exist := 'Y';

Line 7439: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'

7435: AND l_chg_type <> 'E')
7436: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F')
7437: OR (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7438: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS','EMPLOYMENT_CATEGORY',l_configured_dff_segment) OR l_chg_type = 'I'))
7439: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7440: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_chg_type = 'I'))THEN
7441:
7442: debug('Returning Y');
7443: debug_exit(l_proc);

Line 7614: l_contract_type pqp_assignment_attributes_f.contract_type%type;

7610: ,p_contract_type OUT NOCOPY VARCHAR2
7611: ) RETURN NUMBER
7612: IS
7613: l_proc varchar2(72) := g_proc_name||'.get_contract_type';
7614: l_contract_type pqp_assignment_attributes_f.contract_type%type;
7615: l_work_pattern pqp_assignment_attributes_f.work_pattern%type;
7616: l_period_divisor VARCHAR2(10);
7617: l_error_msg VARCHAR2(100);
7618: l_err_no NUMBER;

Line 7615: l_work_pattern pqp_assignment_attributes_f.work_pattern%type;

7611: ) RETURN NUMBER
7612: IS
7613: l_proc varchar2(72) := g_proc_name||'.get_contract_type';
7614: l_contract_type pqp_assignment_attributes_f.contract_type%type;
7615: l_work_pattern pqp_assignment_attributes_f.work_pattern%type;
7616: l_period_divisor VARCHAR2(10);
7617: l_error_msg VARCHAR2(100);
7618: l_err_no NUMBER;
7619: l_error NUMBER;